I have been following the instructions in the 'Microsoft Access 2002 Bible' on how to use the wizard to create a lookup table in Access.
From what it says, it tells me that the field in the table I am doing the lookup in, should be updated to display the new values from the table you are looking up from.
I changed all my field Data Types to 'Text' for the purpose of avoiding any problems with data types.
Here are my tables.
Table1
Table2
Resulting Lookup Properties.
Unfortunately, when I display Table 1 (the table I'm doing the lookup in) in 'DataSheet' view, it doesn't display my Lookup values but I can access them through the Combo box placed in each lookup field / record.
As you can see, comparing to my original Table1 above, the values in Table 1 Field1 remain the same but I can change them to the lookup values using the combo box. I thought the values in the table field I applied the lookup to were supposed to be updated to reflect the lookup values. Why won't they??