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.

Advice needed to create FM records in an external FM file

Rich S
in External Data Sources

Featured Replies

Howdy, all, and happy holiday season.

I'm re-engineering an already-written solution so that all the data entered by a user is stored in an external FM file, instead of locally, to make upgrading the solution in the future easier for all concerned. So, I'm looking for a "best practices" way of doing this. Suggestions?

One problem I've run up against is creating a record in the host file which must create a new (related) record in the data file. Portaling everything isn't the answer, so what is a good way to handle this?

Creating summaries is another problem: am I stuck creating those in the data file since I can't designate an external file/relationship when setting up a Summary in the host file, or...?

TIA for your replies and help!

Create an external reference to the other file, then put a table occurrence of it in the relationships graph. Make a new layout based on this TO.

To create a new record in the external file, go to the layout based on its TO and make a new record. It's as easy as that.

Create an account or sign in to comment

https://fmforums.com/topic/63212-advice-needed-to-create-fm-records-in-an-external-fm-file/
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.