I have a query between two tables, one is an imported table, and the other a fixed product database.
With a query I match the imported tables product name with the one in our product database, usually resulting in multiple matches per product, and eventually a mile long match list.
What I'd like is for the query to rerutn just one match per product, as many of the similar named products in the product database are in fact completely alike, set aise minor differences like table finish, chair cloth color etc. etc.
Essentially the list simply works to tell the salesperson if the warehouse requested are available in at least one color, finish, model etc. etc. based on the form filled out by the customer. So, I only need that 1 match. Its not very precise, but enough to give the order an initial green light.