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!
"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?