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.

Add recrod in related tables

eddyb2
in Relationships

Featured Replies

Hi all,

Am I missing something? Is there not a simple way to create a record in a related table when a record is created in the main table, without using scripts

So for example...

Main table is called Base

2nd table called Year1_Data

3rd Table called Year2_Data

Base is related to Year1_Data by StockID

Base is related to Year2_Data by StockID

When a user creates a new record in Base, can I automatically create a new record in Year1_Data and Year2_Data using the StockID field without using a script, just using the relationship?

(New records will be blank apart from stockID but that's perfect)

Many thanks

Ed

Script triggers sound like the answer here, although you need to upgrade to FM10 first.

Strictly speaking this is a scripted routine, but can be executed without a button.

If you can't upgrade then have a look at the free DO SCRIPT plug-in from myfmbutler

  • Author

Thanks for your reply but not sure if ether are going to work.

The records to base are added via an ODBC connection from Excel so no actual access to the database takes place from the user.

Would a script trigger still take place?

Create an account or sign in to comment

https://fmforums.com/topic/64810-add-recrod-in-related-tables/
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.