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

Need portal with related fields from different tables


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

Recommended Posts

Posted (edited)

Is it possible to create a portal that shows fields from related records in three different tables? If so, how? If not, how do I get around the problem?

I have a many to many relationship between two tables, with a join table in the middle linking them. I need a portal showing fields from each of the many tables, and one field from the join table.

Edit: Problem solved by creating calculation fields in join table to specify the data I need so they are all in one table. Then portal works perfectly. Apologies for bothering the electrons on this board.

Edited by Guest
Problem solved
Posted

Problem solved by creating calculation fields in join table

It shouldn't be necessary: if the portal shows records from the join table, you can place fields from the joined tables directly in the portal.

Posted

Hmmm. I was getting a problem doing that. The fields from the joined tables were showing as if they were global fields - all giving the first record's entry.

Posted

I don't understand the context here. Say you have two tables, A and B, joined by table AB. Now, if you have a portal looking from a table C into table AB, each record in AB has only ONE related record in A and in B - so the first related record is the correct one to display.

This topic is 5576 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.