I am creating an item ordering application which is created by the customer and can include multiple line items.

For an example;

STEP 1. CUSTOMER A will begin to create an order by providing basic details e.g. NAME and LOCATION.

STEP 2. they will then confirm the items they wish to order (from a catalogue of around 2000 items). They select ITEM A and enter the requested QUANTITY. They then might need to add ITEM B to the same order and ITEM C, D, E etc....

These orders can sometimes end up up requiring over 100 items.

 

The problem is I don't know how to achieve this; I could create the form with up to x100 ITEM | QTY ORDERED fields as placeholders OR is there a way to have a form which submits to two forms (tables) linked by an order no?

i.e. ORDER SUMMARY FORM (contains NAME + LOCATION + ORDER NO)

ORDER QUANTITY FORM  (contains ITEM + QUANTITY + ORDER NO)

Any ideas would be much appreciated.