I have a table which requires [Faculty_ID] to be entered; I have a combo list box which allows the user to see the full name of teacher. In the underlying table the ID# is stored, but the (last) name is displayed. I would like to display the full name from the related FACULTY table (without having to store it in this table). When I use the little formula builder in the data property I get the '#Name?' error.
Is there a way to display the related 1->1 data on the form? Also, is there a way to get the combo box list to open up (sync) to the actual related name? My list opens to the *first* last name that matches the last name that is displayed, rather than the one that matches the ID that was entered.
Is there a way to display the related 1->1 data on the form? Also, is there a way to get the combo box list to open up (sync) to the actual related name? My list opens to the *first* last name that matches the last name that is displayed, rather than the one that matches the ID that was entered.