Show records in Portals

[Heathbo]

I have a table 53 records in it. I would like to show those records as a list in another table. Is it possible to do this through a portal?

[dkemme]

Yes, create some relationship between the two tables. If you want to show all the records, create a new field in each record that is a calculation, number, 1 and set the relationship between these two fields, and all 53 records will be seen.

[Ender]

In FM7, you can use the cartesian join operator (X) between any fields in the two tables to create a relationship matching all records between tables.

[Heathbo]

How do I bring the information into the other table? Say for example, I have 2 tables. Table 1 and Table 2. Table 2 has all the records in it. I want to show all the data from Table 2 in Table 1 in a list form like a portal. That way I can stay in Form view and scroll up and down through all the records.

[Heathbo]

OK I got it working. Next question, can you have more than 1 portal on a layout from 2 different tables? On one layout I have two portals from two different tables. I can't get both to show. Its only one or the other. Any thoughts?

[SlimJim]

Showing two portals (non-overlapping) in one layout is not usually a problem this certainly works Ok as far back as FMP3. Are you sure that there are related records via both of the relationships that you are using for the portals?