Twin dependant Lookup

[zorro19s]

I am new at access but I am trying to get a double lookup.
What I mean is that on one table I have Part# and Part Name
On the other table I want to have the option to lookup eather the Part# or Part Name but if I select Part# the Part Name will appear automatically and if I select Part Name the Part# will show up automatically.

I would really appriciate if someone would help me

 

[dawnd3]

Hi Zorro, do you mean on a lookup on a form (vs table)?? If so, you can create combo boxes to look up the values you need. Each combobox has an after update event that can be directed to display the matching part# or Part name depending on which one is selected from the other combo box. Is this what you needed to know? Dawn