Need portal with related fields from different tables

[keelbolt]

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 October 14, 2009 by Guest
Problem solved

[comment]

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.

[keelbolt]

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.

[comment]

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.