Form design

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

II need to design a form that shows data from one table, and enters data into
another table. the 2 tables have a relationship of 1 to many. Thew field that
connects these table is called Part Number. What I'd like to see is for a
certain Part Number only see the rest or the record in one table but be able
to enter a new record in the second table. How can I accomplish this?

Thanks
Alon
 
Alon

The "one" table needs a form to be able to see/edit/add records. The "many"
table needs a form to be able to see/edit/add records (related to the "one"
table row that is the "parent").

Open the "one" form in design mode. Use the subform tool to add the "many"
form as a subform. Relate these two on their common field (?[Part Number]).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top