Inventory w/multiple sources

[wireshop]

I'm creating an inventory program for my small business. Most of the parts have multiple suppliers. Right now I have two tables set up "Supplied Parts" which contains supplier info and the PartID from another table "Inventory". I want to create a purchase order layout that lets the user only add line items(parts) from the chosen supplier. What is the best way to implement this?

[bcooney]

I would suggest reading Jonathan Stark's great article for the section "Product Catalog." You can find it here

[LaRetta]

Excellent recommendation, Barbara, I'll second that ...