How can I select from two related records with the same part number

[Bill_misc_IT]

I have two databases that are related by a part number field. Information is looked-up from the "parts database" and copied to my other database based on the inputted part number. I have duplicate records for two customers that share the same part number. What can I do to be able to specifically choose which record to use for the look-up when there are more than one related records? I'd prefer not to build the table relationship with two related fields.

[dreamingmind]

That's pretty sketchy. Leaves many questions.

Non the less:

I'm assuming you are using a drop down list or something like that to show the related records? If so, you could show data from a second field in the value list. That's a field from the right hand box in the "Edit Value List" dialog.

Regards,

Don