I have also created a sales order page which is used to record all the information from the order. It is in the format of
Main Form - Client Details (Address & Delivery Address etc.)
Subform1 - Orders (Invoice Number, sales person etc.)
Subform2 - Order Details (Ind. product details i.e. size, quantity, price etc.)
I need to be able to create a new form which is used for the delivery tickets. These need to include all the information from the sales order pages but needs to have an individual auto number field. This number is used to identify each order despatched for delivery. There is the possiblity of one order spanning more than one delivery date.
Does anyone have any ideas how i would go about relating the deliveries to the sales orders?
Thanks for your help
Alex
Main Form - Client Details (Address & Delivery Address etc.)
Subform1 - Orders (Invoice Number, sales person etc.)
Subform2 - Order Details (Ind. product details i.e. size, quantity, price etc.)
I need to be able to create a new form which is used for the delivery tickets. These need to include all the information from the sales order pages but needs to have an individual auto number field. This number is used to identify each order despatched for delivery. There is the possiblity of one order spanning more than one delivery date.
Does anyone have any ideas how i would go about relating the deliveries to the sales orders?
Thanks for your help
Alex
