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.

Creation of records via relationship requires child table to have at least one record

Featured Replies

I am finding that when I try to create the first record in a child table via a relationship, it doesn't work (101 record is missing).  But if there is at least one record in the child table, things work as advertised.  Do others have this experience?  Is it a "feature"?  Any way to get around it other than to just add a dummy record to the child?  TIA

This has not been my experience at all.  If you open the attached file and type into the portal's top row, does this work for you?

You will need to provide us more information to help us pin down why it does not work for you.  How are you related?  How are you attempting to create the new child record?  If via script, please post the script.  We can help you figure it out!

AllowCreation.fmp12

I have experienced this as well. In my current project, I create most records via what some call a MagicKey (create a record through an empty global into a related table). For this to work "create record via relationship" must be enabled in the relationship diagram.

An empty table will not allow me to create a record that way. Once a record exists, subsequent records are created without issue. I haven't troubleshooted it to any extend as yet as I haven't had time yet. But I found it happens when I trigger record creation via a UI button, which then invokes a script. It's possibly (thinking a bit more about it) that I'm using the wrong (related) field to trigger the creation of a new record as this is not always a problem. Can't test at the moment as the FMS is busy doing a big import. But this particular import also makes use of the same technique and has no problem creating records even in an empty table.

Something to test (if using this same technique) is using a modifiable related field to create a new record.

Create an account or sign in to comment

Important Information

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

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.