Form and sub-form question (newbie)

  • Thread starter Thread starter Ynot
  • Start date Start date
Y

Ynot

When you use a form and sub-form e.g. a purchase order with a vendor table,
a purchase order table, and a purchase order detail table, I know the vendor
to purchase order relationship has to be part of a query but does the
sub-form, (the detail line items), have to be part of the query also or is
the relationship established by Access because it is a sub-form of the main
form?
 
Generally, the main form has the "One"-side table of a one-to-many
relationship as it's record source, while the sub-form has the "Many"-side
table as it's source. The subform control automatically inserts the primary
key value from the main form into the foreign key of each record in the
subform. This is done through the Link Parent - Link Child properties of
the sub-form control.
 
Back
Top