Creating a related record question

[rwdds]

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.

[comment]

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.

[rwdds]

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!

[Lee Smith]

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