Hello there..
I have a database of a warehouse, I got lots of tables nested into the BASE table that keeps all the records from the received and delivered materials. I got a Yes/No button that shows if the material is IN or OUT the warehouse.
I would like to create a form where you can find IN data on the warehouse by finding on textboxes (I think this would be a query with calls for search).. I know how to do this, but my question is if there is a way to click on the row I would like to add and then on a button display ADD, and It will addall the selected materials into another subform query by automatically adding a shipment number for all those bunch of materials I selected.. same shipment number for all those quantitys.
Is this possible?
Thank you in advance.
I have a database of a warehouse, I got lots of tables nested into the BASE table that keeps all the records from the received and delivered materials. I got a Yes/No button that shows if the material is IN or OUT the warehouse.
I would like to create a form where you can find IN data on the warehouse by finding on textboxes (I think this would be a query with calls for search).. I know how to do this, but my question is if there is a way to click on the row I would like to add and then on a button display ADD, and It will addall the selected materials into another subform query by automatically adding a shipment number for all those bunch of materials I selected.. same shipment number for all those quantitys.
Is this possible?
Thank you in advance.
