Is it possible to have a combobox on a simple input form display the values from one table, but when the combobox is opened, has all of the available values from the 2nd table.
For example, a form with values from a UserTable and a link to Department table.
I want to display all of the values from the UserTable:
But I want Department to be a combobox that displays the appropriate Department for each record in the UserTable when navigating, but when opened, shows all of the Departments from the DepartmentTable.
Is this possible?
Thanks for any help.