Jump to content
Sign in to follow this  
john9210

Filtering records

Recommended Posts

FM 8.5. I have three tables: Logs, Miles, and Tax. Logs is related to Miles via record ID’s. I want to place a portal in Logs to only display records from Miles that are filtered by a criteria in Tax table. Is there a way to do this? For example, in the portal I want to show only those miles records that meet the criteria Flag = 1 in the related Tax table.

Share this post


Link to post
Share on other sites

You haven't told us what the heck Miles and Tax have to do with each other. I assume that there is a field in Miles that is a foreign key from Taxes? Because without some kind of connection between Miles and Tax there is no logical reason for what you say you want to do.

There's a couple ways to do it, depending on whether the Tax::Flag field can be looked up into Miles, that a Miles records is ALWAYS created after the Tax has been flagged. I assume not, because that is too simple.

1. Assuming there is a Tax ID in Miles, and FileMaker 8.5. In Logs create a "constant1" calculation field, =1. Create a relationship to Tax from that to the Flag. Create another calculation field in Logs, unstored, List ( Tax_Flag::TaxID ). This will evaluate to a return-separated list of the TaxIDs where Flag=1.

Create a relationship from that field to the TaxID field of Miles. That will give you the portal.

2. Assuming that Miles records are ALWAYS created after their Tax has been flagged. You could look up the Tax::Flag into Miles. Then just use a constant1 relationship from Logs to that flag field.

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  

  • Who Viewed the Topic

    1 member has viewed this topic:
    siroos12 
×

Important Information

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