Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

I think it is a matter of relationships but I can’t make it work.

What I’d like to accomplish is:

To show in the portal coloured in red the names of all contacts (only once each contact) related to the properties of a particular building.

Once shown, can I skip them by type of relationship using the portal filter I.e. TypeOfRelationships::Relationship (or whatever fixed table) = "Owner"?

I know is not correct in my sample file, I have just done it to show with an example what I need to accomplish and trying to explain.

Thanks to all for your help.

Relationships.zip

Posted

Before getting to your question:

You have a join table between Buildings and Properties, indicating that a property could be in more then one building. That doesn't seem to make sense.

Posted

Thank you Comment.

Once again you are an expert hitting the nail on the head.

Is not just exactly what I need, but makes perfectly the work.

If you don't mind, let me work a bit more on it and I'll be back with some more accurate question about it.

Thanks again.

This topic is 4625 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
×
×
  • Create New...

Important Information

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