TheCrusher
New member
- Local time
- Today, 13:06
- Joined
- May 27, 2002
- Messages
- 8
Does anyone have a solution for the following?:
I have a table with the following info:
(feilds)
PO#
Supplier
ItemGroup
ItemNumber
Qty
I would like to use the qty feild to determine how many new records to INSERT into the serials table.
example:
========
PO = 5545
Supplier = ACME
ItemGroup = VCR
ItemNumber = son234-14
qty = 3
when the user searches for that PO in the form, the subform (which is the serials table) has 3 new records of the same data as above (qty = 3). This will allow me to scan 3 serial numbers of the same product. I basically need to query 1 PO number and output to the serials table that data, 'x' number of times based on the qty. If qty = 50 then it inserts 50 of the same record into the serials table.
Any way I can do this??
Thanks
Doug McC
I have a table with the following info:
(feilds)
PO#
Supplier
ItemGroup
ItemNumber
Qty
I would like to use the qty feild to determine how many new records to INSERT into the serials table.
example:
========
PO = 5545
Supplier = ACME
ItemGroup = VCR
ItemNumber = son234-14
qty = 3
when the user searches for that PO in the form, the subform (which is the serials table) has 3 new records of the same data as above (qty = 3). This will allow me to scan 3 serial numbers of the same product. I basically need to query 1 PO number and output to the serials table that data, 'x' number of times based on the qty. If qty = 50 then it inserts 50 of the same record into the serials table.
Any way I can do this??
Thanks
Doug McC