Duplicate records in a Drop Down Field
I have a database that consists of a library of 'product names', all under various 'categories'. Some categories have more than one product with the same product item name. These are distinguishable by other data, such as 'make' or 'style'.
A layout listing of all product, includes those with the same product name.
An Order layout, has a drop down field for the 'category' that will lookup and list all the 'categories' from the library. The next field is also a drop down field for the 'product name' that will lookup and list only those 'product names' which are entered in the library under the selected 'category'.
However, it will not list the products with the same name, just one product being the first recorded. All others with the same name will not appear in this drop down field.