March 18, 201114 yr 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.
March 18, 201114 yr 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.
March 18, 201114 yr Author 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!
March 19, 201114 yr 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
Create an account or sign in to comment