Well I'm working on my training application as I call it. It has two tables CLIENT and EMPLOYEE with client having a foreign key to employee. The key lets you know which employee helped which client last.
I have a Form that lays out the CLIENT information in List view and I want the "lasted helped by" field to be a combo box displaying the last employee who helped the client with the option to change the value via the combo box. I'm able to bind the box to the data source for the available EMPLOYEES but it doesn't seem to work in terms of showing the foreign key value. I know I'm missing something or doing something wrong but don't know where to look for more information on the subject. Could someone make a suggestion?
I suspect that binding may not be an option since I want the combo to drop down to <lastname, firstname> values while updating in the background to a numeric key value.