Need Help!!!

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
 
Use DAO code to prompt for the Qty number of serial numbers (i.e. create a loop based upon Qty) and add them to your serial number table.
 

Users who are viewing this thread

Back
Top Bottom