I want to link or restrict all my individual products to their respective suppliers, so that when I select a supplier in, for instance, a purchase subform, only the products of that particular supplier show and not the entire list of products.
In addition, I need to allow duplicate product entries, as several suppliers often produce a product that has the same name (in this case, a type of wine, based on the same grape), but is entirely different by nature.
Many thanks in advance!