Value list based on multiple criteria - again

[Gene McFadden]

Same question as before but with simplified example...using two tables.

wo_test inv_test

------- --------

techname techname

serialnum serialnum

stockdate

usedate

I enter "techname" , "stockdate", and "serialnum" into inv_test.

My technicians use wo_test. I only want the technicians to see

"serialnum" for their matching "techname" and only when "usedate" is empty.

I created a relationship: techname=inv_test:techname which displays only the

"serialnum" matching "techname" which if fine - but I need to filter out all

"serialnum" records that have a "usedate".

[Wendy T]

If I understand you correctly, this is a simple fix.

Define a new calc field in the wo_test database to concatenate techname & usedate. Use this field as the basis for the relationship instead of using techname. Only where the usedate is empty will this relationship match, giving you the filtering you want.

cheers,

Wendy

[Gene McFadden]

Thanks much - works great!!