linking without keys?

[helloworld]

hey there...this might be a newbie question, but can you build a form that links two tables without having the user enter a foreign key?

 

[Pat Hartman]

If you use a form with a subform and set the master/child link properly, Access will automatically populate the foreign key when you add a row via the subform.

 

[helloworld]

Thanks a lot Pat. That worked!