is there a simple way to create 1-to-many forms?

  • Thread starter Thread starter Kevin
  • Start date Start date
Kevin said:
order with multiple items (number not known) - that sort of thing.

Suggestions?
Click to expand...

Typically done with a main form bound to the orders table and a subform bound to
a line-items table. An OrderID field or Fields would be used for the table
relationship and the linking of the form/subform.

I usually create the subform first as either a datasheet or continuous form and
then drag that from the db window onto the design view of the main form.
 
Back
Top