I am creating a b/dase to track despatches from a warehouse. most of it ius in place and working but I have one problem I need to solve.
I have a form (frmDespatchInput) which is used to enter the products that are being despatched, each time the form loads it starts a new record and each record refers to 1 item being ordered, The form is bound to a table (tblDespatchDetails) that contains the details of all the items order. I would like to use this form so users can build up an order of many different items but tblDespatchDetails must contain every single item of every single order, so I have created a column in tblDespatchDetails call DespatchNo.
I want the form to automatically enter an order number into this column each time a new record is created, then when the user has finished building the order I want them to be able to press a command button or something on the form which increases the order number by 1 and then continues automatically entering that number until a new order number is required.
I hope that made sense.
I have a form (frmDespatchInput) which is used to enter the products that are being despatched, each time the form loads it starts a new record and each record refers to 1 item being ordered, The form is bound to a table (tblDespatchDetails) that contains the details of all the items order. I would like to use this form so users can build up an order of many different items but tblDespatchDetails must contain every single item of every single order, so I have created a column in tblDespatchDetails call DespatchNo.
I want the form to automatically enter an order number into this column each time a new record is created, then when the user has finished building the order I want them to be able to press a command button or something on the form which increases the order number by 1 and then continues automatically entering that number until a new order number is required.
I hope that made sense.
