Pulling cost for container by matching container number to the part number

[Saniphor]

I am hopeful that someone here would be able to help me. I am rather new to Access.

I have two tables the product file table and the packaging component table. Pnum (product number is a primary key in both tables) ComponentPNum is also a primary key in the packaging component table.



What I am trying to do is look up the cost of DrumNum by matching the DrumNum to the Pnum in the same table.

SELECT PRODFIL2.PNAME1 AS [Product Name], PRODFIL2.PNUM AS [Product #], PRODFIL2.UP AS [Packaging Unit], PRODFIL2.DRMNUM AS [Container #], PRODFIL2_PackagingComponent.ComponentPNUM AS [Lid #], PRODFIL2.lcost AS [Container Cost]FROM PRODFIL2 INNER JOIN PRODFIL2_PackagingComponent ON PRODFIL2.[PNUM] = PRODFIL2_PackagingComponent.[PNUM]WHERE (([qryPackagingCost]![Container #]=[PRODFIL2]![PNUM]));

[Rixxe]

This might help:
http://allenbrowne.com/ser-06.html

[Saniphor]

Thank you for your help Rixxe! That got it