enigma12121
Programmer
I want to know an easy way to fill a record of a table with the data from another table
Here is goes. Right now I have two tables one is for shipping the other is the Sales Order behind it. When I want to ship an item I open the subform for shipping and it copies the Sales order number into the sub form. it then populates a drop down box with all the items in that order. I want to know how I can copy the rest of the data from the Sales Order Table into the Shipping table using only those two pieces of information.
THanks in advance
Here is goes. Right now I have two tables one is for shipping the other is the Sales Order behind it. When I want to ship an item I open the subform for shipping and it copies the Sales order number into the sub form. it then populates a drop down box with all the items in that order. I want to know how I can copy the rest of the data from the Sales Order Table into the Shipping table using only those two pieces of information.
THanks in advance