October 11, 200718 yr 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?
October 14, 200718 yr I would suggest reading Jonathan Stark's great article for the section "Product Catalog." You can find it here
Create an account or sign in to comment