Forms design for one-to-one tables

[Guest]

What's the best way to design a form to populate a table (tblPhase2), which
is related on a one-to-one basis with another table (tblPhase1) which has
already been populated. I would like the user to enter the data from three
fields (which will be unique to only onerecord) from tblPhase1 and then fill
in frmPhase2, linking the two together without ever seeing the primary key
fields. I have tried using combo boxes based on a query, but I just can't
make it work. Suggestions?

 

[Guest]

Create a subform out of tblPhase2 on the form used for populating tblPhase1.

 

[Joan Wild]

There's a sample database at
http://www.mvps.org/access/tables/tbl0013.htm
that should help.

 

[Guest]

That will do it. Thanks for your help!

There's a sample database at
http://www.mvps.org/access/tables/tbl0013.htm
that should help.

 

[Guest]

Thank you. I appreciate your help!
Oh, and I pick strong and cheap.