Jump to content

Check box across 2 files


Kristen
 Share

This topic is 6552 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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???

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6552 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.