Forms design for one-to-one tables

  • Thread starter Babe in the Woods
  • Start date
B

Babe in the Woods

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?
 
J

Jerry Whittle

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