Jump to content
Sign in to follow this  

Add recrod in related tables

Recommended Posts

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


Share this post

Link to post
Share on other sites

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

Share this post

Link to post
Share on other sites

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?

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

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