Hi all,
I think i have a sort of unique situation and am facing a possible logic issue.
Back-Story:
I can qry several sets of tables needed and apply to my access db.
the 1st table, lists the serial number (Service Tag) of a computer as well as all of the units components by part_number and Description.
The 2nd table lists a set of part numbers, and the Demand of those part numbers by our clients.
(Exe. part_number = ABC12 Demand = 50)
the 3rd table, lists all the validated substitutions for part number A, if it is out of stock.
(Exe. From_Part_Number = ABC12 To_Part_Number = CBA12)
Currently i can get Access to tell me which parts are in the unit, that are also in the Demand File, but if the part number is not in the demand file (or is at zero pcs needed, I need it to look to see if there is a valid substitute part, and check its demand.
This is what compares the unit to current demand.
I can provide more info if this is not enough
SELECT
BOM_File.LICENSE_PLATE,
BOM_File.PART_NUMBER,
BOM_File.DESCRIPTION,
Current_Demand.Actual_Demand
FROM BOM_File, Current_Demand
Where BOM_File.Part_Number = Current_Demand.DTSO_Part_Num
And Current_Demand.Actual_Demand > 0
I think i have a sort of unique situation and am facing a possible logic issue.
Back-Story:
I can qry several sets of tables needed and apply to my access db.
the 1st table, lists the serial number (Service Tag) of a computer as well as all of the units components by part_number and Description.
The 2nd table lists a set of part numbers, and the Demand of those part numbers by our clients.
(Exe. part_number = ABC12 Demand = 50)
the 3rd table, lists all the validated substitutions for part number A, if it is out of stock.
(Exe. From_Part_Number = ABC12 To_Part_Number = CBA12)
Currently i can get Access to tell me which parts are in the unit, that are also in the Demand File, but if the part number is not in the demand file (or is at zero pcs needed, I need it to look to see if there is a valid substitute part, and check its demand.
This is what compares the unit to current demand.
I can provide more info if this is not enough
SELECT
BOM_File.LICENSE_PLATE,
BOM_File.PART_NUMBER,
BOM_File.DESCRIPTION,
Current_Demand.Actual_Demand
FROM BOM_File, Current_Demand
Where BOM_File.Part_Number = Current_Demand.DTSO_Part_Num
And Current_Demand.Actual_Demand > 0