Form with an unkonwn number of entries?

[bakkouz]

OK guys, here is the case:
I want to create a 'Purchase orders' Form. the form would look something like this:

Item number. Item description. Item quantity. other notes.

now, the purchase order could contain multiple entries(Items), but not specific to a certain number. like for example, in a single order you could place one item or two or five or ten. I could create a specific number of text boxes for the user to enter a certain amount of items, like seven or ten but this would be inefficient, non-practical and would clutter the form.



So, what would be the best practice of creating such a form?

[pbaldy]

As answered elsewhere:

Typically this would be done with a form/subform, where the form was bound to an orders table that contained the basic order info and the subform was bound to an order details table that contained a record for each item.

[bakkouz]

Pbaldy, could you please elaborate more?

[pbaldy]

As elaborated elsewhere, check out the Northwind sample db that comes with Access.