Lookup Field?

[pdbowling]

Hello all,
I have 2 tables.

PO and Repair_Tag

PO table
PO(txt)....Vendor(num).......UserCode(txt)......etc

Repair_Tag table
Repair_Tag(txt)......UserCode(txt)..........Vendor(num).......PO(txt)........etc

My question is:
Is it possible to make the field PO in Repair_Tag a lookup value that lists field PO from the table PO with only the PO values that have a Vendor and User Code that match the current record in Repair_Tag?

ie Select PO from PO where vendor = currentRecord.vendor and UserCode = currentRecord.UserCode

I tried setting up the lookup field but was uncertain how to access 'currentRecord' if it is possible.

Thanks everyone.
PB

 

[neileg]

Do it on a form. Create a combo based on a query that uses the UserCode displayed on the form as a criterion. Using lookups at table level are OK for simple lists but once you want something more interactive, they get in the way.