setting lookup field priority?

[dm1]

Hi folks,

I have a datasheet form with a number of columns, in this order, they are: Item #, part #, product desc. The last two are drop down lists. The part # is the unique field.

The problem is this: If I paste a number of items into the columns (line by line), the lookup occurs first on the part #, then on the product desc. Sounds fine, until I come across 2 different part #s with an identical description - at which point the 1st item matching the desc is picked up, the part # being ignored, so a duplicate entry occurs.

I can resolve this by reversing the column order, or hiding the product description field, but i wondered if anyone had a better solution - and nope, can't set the prod desc field to unique (Grrr...)?

Cheers, Jon.

 

[kathryn]

Sorry, but I have a few questions. Does your form have 3 columns or 5? In other words are the last two drop-down fields part# and productdesc or two other fields.

I don't know what you mean by the lookup occuring first on the part number. What lookup??

It may help if you describe the data upon which the form is based; is it one table, or a query using multiple tables? Also, could you show some sample data in the form, give a sample of a row that you try to paste, what you want to be the result of the paste, and what happens instead.

Sorry to ask so many questions.

Kathryn