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.

Creating a related record question

Featured Replies

I’m a newb trying to understand FM relational design. My question is, if 2 tables are properly defined with a relationship and a new recored is created in the parent table, is a new [related] record automatically created in the child table? If not, what are the basic scripting elements to create the related record and programmatically populate fields with data? No portals are being utilized for this project.

is a new [related] record automatically created in the child table?

No. If it were, it would be entirely empty except for the parent ID, thus useless.

If not, what are the basic scripting elements to create the related record

If you don't use a portal, it's best to put the current parent's ID in a script variable (or script parameter), go to a layout of the child table, create a new record and set the foreign key with the value in the $variable (or parameter). Then proceed to populate the child fields.

  • Author

TU! Apologies for the 2 posts. Right after I posted the first, then realized I was in an FM 9 area, didn't think anyone would reply!

You need to read the descriptions better. The General Topics for each Version is for discussion of the new tools that came out with that particular version.

We have a category for Relationships, which is were you will find this in a few minutes.

Lee

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.