LINKING TABLES

I'm so close.

I've got a table full of parts that I have to marry up to table full of
model numbers.

I've gotten the two to link Via

SELECT [Price List].ID, [Price List].PrtNum, [Price List].Nomen, [Price
List].[Prod Line], [Price List].[U/I], [Price List].[Price Code], [Price
List].[Retail Price], [Price List].[Standard Price], [Price List].[U/P],
[Price List].Cat, [Price List].[Item Name], [Price List].Make, [Price List]
..Details, MdlLst.Models
FROM [Price List] LEFT JOIN MdlLst ON [Price List].MdlLst_ID=MdlLst.ID;

My only problem is that it seems I can only choose one model number per
part, when I actually need to assign as many as 30 model numbers to each
part.

I am truly a novice in WAY over my head here. Can someone help me out.

r/s
Treading Water

--
Message posted via http://www.accessmonster.com

SELECT MdlLst.ID AS xyz_ID_xyz, MdlLst.Models AS xyz_DispExpr_xyz,
MdlLst.Models AS Expr1
FROM MdlLst
ORDER BY MdlLst.Models;

This is how I got them to link. I added the wrong code last time.

Sorry

--
Message posted via http://www.accessmonster.com