I am selling several classrooms’ worth of educational materials. Many of the classrooms contain the same items, but from different brands, and therefore, they have different retail values. I have made a table of Materials, organized by which lesson it is, with each column showing the retail price from a different vendor.
On another table, “Inventory List”, I’m identifying each specific item by selecting the generic material name, brand, etc. (see below) I’d like to be able to link to the specific retail price of that brand for that item, but I don’t know how to set it up correctly, as I’m not sure how to say, “Hey, all the prices in this column are linked to this brand only.” Help!