Check box across 2 files

[Kristen]

I have 2 related files: donor.fp5 and vendor.fp5

vendor contains a check box field with Yes or No as the options, and another field company name. Donor has a field: Non-Profit, which is a drop down from CompanyName in vendor. I want to be able to do a find in donor for all the Non-Profits that have the check box marked YES in vendor. I will eventually be performing a script from donor.fp5 with these records, so if I can script the requests that I want that would be good also. I am sure this can be done with the creation of some "holder" fields of sorts, but I am stumped. Any thoughts???

[Ugo DI LUCA]

As you may also want to do the reverse, add

- one globalYN (text) in Donor and attach to it a value list "Yes/No".

- one calculation c_LeftKey = NonProfit&" "&globalYN

Then, in Vendor a calculation c_RightKey = CompanyName&" "&checkboxYN

Establish a relationship between the c_LeftKey and c_RightKey and see the result in a portal or trigger a GTRR.

Of course, if you could have a key rather than a name, this would be safer.