If I understand your question, you enter the foreign key info when you create
a new record. Example: You enter a new invoice, the foreign key will be the
customerID that you will have to select.

Susita wrote:
I am attempting to learn Access via the demos - but still need help - I am
setting up relationship between a Sales, Supplier & Customer tables. When I
create a foreign field in these tables - do I need to populate this new field
manually? If the Access issued ID numbers for each customer and supplier are
present in those tables - how can I get those ID numbers to be recognized in
the foreign fields? There are quite a few customers - with many Sales. . .
Please help -

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200908/1