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, 200916 yr by Guest
Problem solved

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.

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.

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.