Hi, everyone.
I have one simple table:
ID
Lookup_Table
Lookup_ID
In multiple other tables, I have a field called 'Name'. I want to add a field in a datasheet form that will populate with 'Name' based on the Lookup_ID and the Lookup_Table. In other words, if my record set looks like this:
ID Lookup_Table Lookup_ID 1 tbl_Parts 50 2 tbl_Slots 50
Then for the first record, I want the field in the form to return the 'Name' of Lookup_ID 50 in tbl_Parts and the second record would return the 'Name' of Lookup_ID 50 in tbl_Slots. The output in the form then looks like this:
ID Lookup_Table Lookup_ID Name 1 tbl_Parts 50 Name_Of_ID_50_From_tbl_Parts 2 tbl_Slots 50 Name_Of_ID_50_From_tbl_Slots
How can I accomplish this?
Thanks,
jj