Hello.. let me explain..
I got a table with all the products I got in stock in a warehouse.
I would like to create a form with 2 subforms and search fields (I know how to filter search fields on the first subform).
Then when I have a new shipment Ill open that form to search for the products that my client need, then select them from the left subform checkbox (Instock/notInstock) And add them on the second subform (on the right) via a button called add..
what im looking for is that when I open the form, it automatically creates the same autonumber for all the shipments, so when I select my products and click add.. that autonumber will display in the table as the SHIPMENTNUMBER for all the selected products.
That way I could create invoices and reports based on the Shipment number that will display all the products delivered from that transaction.
Could somebody help me with an example?
I got a table with all the products I got in stock in a warehouse.
I would like to create a form with 2 subforms and search fields (I know how to filter search fields on the first subform).
Then when I have a new shipment Ill open that form to search for the products that my client need, then select them from the left subform checkbox (Instock/notInstock) And add them on the second subform (on the right) via a button called add..
what im looking for is that when I open the form, it automatically creates the same autonumber for all the shipments, so when I select my products and click add.. that autonumber will display in the table as the SHIPMENTNUMBER for all the selected products.
That way I could create invoices and reports based on the Shipment number that will display all the products delivered from that transaction.
Could somebody help me with an example?
