table relationship

[fadetoblack]

Hi, I have 2 related. In the first table I have a primary key number and another ID number.

On the 2nd table which is related by the PrimKey I want the ID number to come up automatically. I can't remember how to do this. Can anyone help?

thanks

 

[*Pete*]

You could use a lookup field type in the Second table to lookup the values from the first table.

 

[Pat Hartman]

The normal process is to use a main form with a subform. As long as the master/child links are properly set, the foreign key in table2 will be automatically populated.