AnsweredAssumed Answered

Inventory Product with multiple vendors

Question asked by moderndesigns9 on Jan 20, 2019
Latest reply on Jan 20, 2019 by moderndesigns9

Okay, so I am making a Database for a steel company and running into a roadblock and don't really understand where to go from here!


Current Tables





"Join Table For Products and Vendors"


So I am able to create multiple products


and also able to create multiple vendors


and with my join table, I am able to assign multiple vendors to one specific product! Great so far!



Now when on my Sales Layout I need to select one of the products to sell to a Client


do I create a table occurrence  of the "Join table"  and relate it to my Sales Table


or do i need another type of table to grab data from the Join table of Products and Vendors?