Add multiple records depending upon quantity

J

jhunter

=====
ISSUE
=====
a) I have the following tables...
Sales
Sales Details
Maintenance
Maintenance Details

b) I have an append query (see below) CORRECTLY adds records (FROM
Sales/Sales Details TO Maintenance/Maintenance Details) FOR EVERY LINE
ITEM ON THE SALE.

c) How can I modify this append query to handle MULTIPLE QUANTITIES on
the Sale (see example below)?


=======
EXAMPLE
=======
Everything works perfectly if there is only ONE of EACH item on the
sale. If there are more than one, of an item on the sale, it still only
adds one to the Maintenance/Maintenance Details tables.


=======
QUERIES
=======

==SELECT QUERY (qryALLsales___FILTERbyFORM)==
SELECT DISTINCTROW qryALLsales___.*
FROM qryALLsales___
WHERE (((qryALLsales___.OrderID)=[Forms]![frmALLsa______]![OrderID]));

==APPEND QUERY (qapALLmn______APPEfromSALES)==
INSERT INTO tblALLmn______ ( OrderID, ProductID, IDClient,
SerialNumberMaintenance, IDManufacturerMaintenance, VendorMaintenance,
NameMaintenance, Dc___NameMaintenance, Dcs__NameMaintenance,
Dcss_NameMaintenance, DcsssNameMaintenance )
SELECT qryALLsales___FILTERbyFORM.OrderID,
qryALLsales___FILTERbyFORM.ProductID,
qryALLsales___FILTERbyFORM.qryALLcl______.IDClient, "0" AS
SerialNumberOriginal, qryALLsales___FILTERbyFORM.DIDManufacturer,
qryALLsales___FILTERbyFORM.DVendor, qryALLsales___FILTERbyFORM.DName,
qryALLsales___FILTERbyFORM.Dc___Name,
qryALLsales___FILTERbyFORM.Dcs__Name,
qryALLsales___FILTERbyFORM.Dcss_Name,
qryALLsales___FILTERbyFORM.DcsssName
FROM qryALLsales___FILTERbyFORM
WHERE (((qryALLsales___FILTERbyFORM.DVendor)<>"HCI"));


==========
BACKGROUND
==========
O/S = WinXP Pro
Patches Installed

Software = Access 2000
Patches Installed


=========
Thanks!!!
THE END
=========
 
Top