Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Show records in Portals

Featured Replies

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?

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.

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.

  • 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.

  • 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?

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

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.