Autofill Columns of Table with Values from Another Table

[atrangi4u]

Hello

I have two tables tblCList and tblCode. The primary key of tblClist is an autogenerated number which is the foreign key to the tblCode.

The tblCList has another column names sClist.

whenever I import values from Excel into the tblCode, I need Access to look up the text values from the sClist in the tblClist and insert the appropriate number corresponding to the entry in tblCode.

Please Help


Thanks

 

[aleb]

How do you know that tblcode has respective value if you loading smth from another source ? Is there any field in outer source which can be used as a ref a value in tblClist?

 

[Mile-O]

You can use the DLookup() domain aggregate function. Further details are available in the Help files.