Purchase Orders

[DJohns]

I would like to add multiple items to one purchase order record. How would I do that using a split form?



New user of Access.

Thanks for any help you can give.

Dick

[ranman256]

you wouldnt.
make a master form fOrder (bound to tORders)
and a subform bound to tOrderDetail. (bound on field OrderID)

then it behaves like an online shopping cart, 1 order, with many items.

[pbaldy]

I don't think a split form is appropriate. I'd use a form bound to the purchase order and a subform bound to the items table. Master/child links would keep them in sync.