Jump to content

Creating a related record question


rwdds
 Share

This topic is 4344 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 4344 days old. Please don't post here. Open a new topic instead.

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
 Share

×
×
  • Create New...

Important Information

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