Search results

I have a table 'Table1' where 'Field 1' represents ID_Numbers. I wanted to see member_names in that column for reference so I did a lookup on that table using 'Table2'. 'Field1' in 'Table1' now displays member_names instead of ID_Numbers. I now want the looked up values displayed in...

I have created a lookup in an access table field which is based on the values in another table. My understanding is that the table I'm doing the lookup in is supposed to display the looked up value. In my case it hasn't. Would anyone know if there is a setting to make this happen?