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.

Unable to add records through portal in 3 related table database

ShamanTonberry
in Portals

Featured Replies

Hello everyone,

I am fairly new to FileMaker and I have been trying to find a solution to my problem on all sorts of forums and in all forms of tutorials, but have been drawing a blank so far. Maybe you can help me.

I am currently in the process of preparing a historical database of officials delegated to supervise order in private estates. The existence of both the officials and the estates needs to be confirmed by historical sources. So the 3 tables are: Sources, Jito (the officials) and Jito-shiki (the jurisdictions in estates). One source can mention multiple officials and estates; an official may appear in many sources and hold jurisdiction in numerous estates; lastly, a given estate may appear in multiple sources and may have been under the jurisdiction of numerous officials during that time period - this led me to conclude that this is a many-to-many-to-many relationship.

Each record has a form view with its own fields as well as most essential information drawn from related tables via portal. I allowed for the creation of new records, so that I only need to type in the missing details in related tables and everything worked - so far, so good. The problem began when I wanted to add more related records via portal. For some reason it would only show one record and no new line would appear. I tried to create a button that would simply add another related record, but they wouldn't appear in the portal. Does anyone have any idea what I might be doing wrong?

The relationship graph is available here:
https://drive.google.com/open?id=1N_pGUcavM1eS5BegpQhKgUZVvITNr6cy

Why not just post the graph here?  Might be easier to post a sample file.

Do you have 'Allow creation of records in this table via this relationship' enabled?

  • Author

I tried to upload the graph directly, but it wouldn't let me for some reason. And yes, I have 'Allow creation of records in this table via this relationship' enabled on all related tables.

Maybe the fields aren't actually inside the portal? An easy way to check is, in layout mode, click the portal and then nudge it with an arrow key. Did the fields move along with the portal?

  • Author

Thank you, that solved the issue! I messed with the size of the portals themselves and fields were sticking out of them

Create an account or sign in to comment

https://fmforums.com/topic/106373-unable-to-add-records-through-portal-in-3-related-table-database/
Go to topic listing

Important Information

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

I accept

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.