Blank Records Saved

[Guest]

I made a form with a subform to enter in data into a table. The form inputs
the work order number, the subform inputs the items ordered. When I save the
information, I get two records in my table, one says the work order & items
ordered, the other just has the work oreder number with no items. Can Not
have the blank record of only the work order stored in my table?

 

[Rick Brandt]

I made a form with a subform to enter in data into a table. The form
inputs the work order number, the subform inputs the items ordered.
When I save the information, I get two records in my table, one says
the work order & items ordered, the other just has the work oreder
number with no items. Can Not have the blank record of only the work
order stored in my table?

If your using a form/subform you should have two tables. The main form is bound
to the parent "Orders" table and the subform is bound to the child "LineItems"
table.