I am trying to create a combo box or list box that looks up the values in a table, I want it to display three column, when I select the value I want from the list, three fields will be filled in. For example I have a combo box that displays [course title] [course ID] [course hours] when I select the course title, the course ID and course hours will also get selected and filled in the table.
Course Title Course ID Course Hours
WORKING ALOFT DSC002C 4
WORKPLACE SAFETY DSC002D 2I have only been able to make the first column value get displayed in the table when I select course title. I want all three to be shown in the table