2subforms

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

Guest

I have two forms where I would like to see all records for a GIVEN on the one
one screen - but two tables- tied together with a common field. Right now I
have one as a main form and one as a subform. The subform is fine but the
main form ony show ONE record for the day. Would like to see all records for
given day - on main form( or do need to make it a subform). Not sure how to
have 2 subform tied together on a Form.

Please help,
Barb
 
In a main form / sub form scenario the main forms primary key resides in the
subform as a foreign key. This will relate all the subform data to the main
form. The main form should only show one record, the subform is the one that
should show multiple records.

For example I am a customer of XYZ company. When they call up me in the main
form, the subform will show all the orders I placed. Thus, the one to many
relationship.

If you are not getting the data you want, then either your table design(s)
is/are incorrect or your design of your mainform / subform is backwards.
 
Back
Top