AccessTexas
Registered User.
- Local time
- Today, 00:25
- Joined
- Dec 3, 2005
- Messages
- 18
I have a task where I transfer an item number out of one warehouse and into the other. I'd like to drop it in one table that would list the warehouse, item number, quantity(plus or minus) as a mirror record other than the quantity.
Is there a way to have the form create both records or do I have to enter both separately?
Item No. Description Quantity Warehouse Transfer No.
53085 1x3 Nail -6 3 12345
53085 1x3 Nail 6 4 12345
53096 2x3 Nail 15 3 89765
53096 2x3 Nail -15 4 89765
Is there a way to have the form create both records or do I have to enter both separately?
Item No. Description Quantity Warehouse Transfer No.
53085 1x3 Nail -6 3 12345
53085 1x3 Nail 6 4 12345
53096 2x3 Nail 15 3 89765
53096 2x3 Nail -15 4 89765
Last edited:
