Jump to content
Sign in to follow this  
theoph

Value List Filtering

Recommended Posts

I want to recreate a "Pop Up" Value List with people who are marked as donors. Currently, I'm getting all people, regardless if their "donor" field is set to "Yes." How can I get a value list with only people who are also marked as "donors?"

Share this post


Link to post
Share on other sites

Your relationship to People needs to include the fact that they are donors. So, you need a second predicate, Yes=Donor. You need a calc field that = "Yes" on the parent side of the relationship.

Edited by Guest

Share this post


Link to post
Share on other sites

Not sure if I understand . . . been a while since I worked with FileMaker.

Got two databases, one is called "Oikos" and the other "Donations." Oikos includes all the names and addresses of families who are donors. However, not all families are current donors, so I have a another field in Oikos call "donor," which simply contains either a "Yes" or "No."

The other database is called "Donations" and includes all the specific donations made by the families. When I enter a new record in "Donations," I'm wanting to have a "Pop-up" or "Drop-down" list to appear that will only have families in "Oikos" who are current and have "Yes" in the donor field.

So where to I put that condition that would give me a Value List that contains current donors in the Oikos database?

Share this post


Link to post
Share on other sites

bcooney,

Thanks a bunch!

The example helped a lot. Got the Value List to do what I wanted.

:

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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