Lookup issue with duplicate key data

[sbutler]

Here's my situation. I have a quote system (FM7) which uses a key field "Vendor Part #" to lookup prices from a pricebook table. I know it's stupid, but the pricebook may contain duplicate Vendor Part#s, even though the description and prices are different. Since FM will automatically return the data from the first match it finds, this may cause someone to quote the incorrect item. When a user enters a Vendor Part # in the Quote Form, I need FM to alert the user if duplicate Vendor Part #s are found in the Pricebook and give them the choice of which record to copy the data from. It sounds complicated, but the MS Access Quote System we are replacing does this. Removing the duplicate Vendor Part#s from the Pricebook is not an option. Any ideas???

[transpower]

Make a compound index of Vendor Part# plus description; this should be unique.