PO when a manufacturer is also a supplier
I have a solution and I am creating a Purchase Order section. I have a parts catalog and within that table I have a field that is the primary supplier and also a secondary supplier for each part. I also have a Manufacturer Table and a Vendors table and they are connected by a Join table (many to many). I want to use that field in the parts table to group items on PO’s by supplier. Now to my question:
There are times when we buy directly from the Manufacturer and other times when we buy from a vendor (distributor) instead of the manufacturer. Is it best to enter the manufacturers who we buy from into both tables or is there a way to point back to the manufacturer’s table when they are both the manufacturer and vendor?