Hi Bruce,
I have a drop list showing items linked to a specific supplier, from Table 1.
This drop list is filtered by the supplier selected. (suppliers in table 2)
I have an item master file, table 3, which contains the item list with descriptions, etc.
I would like a lookup, (related table option) from my drop list to display the item description from table 3, while listing items from table 1 for the selected supplier.