April 16, 200520 yr 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?
April 16, 200520 yr 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.
April 16, 200520 yr 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.
April 18, 200520 yr Author 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.
April 19, 200520 yr Author 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?
April 25, 200520 yr 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?
Create an account or sign in to comment