I'm in the process of designing a Chefs Order system. While its working as required I have been asked to provide the following.
The order form works as per a continuous form using the Order No to link both main and sub forms.
However as they order some 120 items each week, they don't want to have to create an order form with this number of items each week.
I have created an append query from the lists. While this will insert the data into the orders table, it does not associate its self with the order No (Links to main form)to display the order.
Question is, How can I associate each record with the order No?, once I have appended the data in the table.