AnsweredAssumed Answered

Set Child fk to Parent PK

Question asked by cmj on Jul 18, 2017
Latest reply on Jul 23, 2017 by SteveMartino

Still a new to FM but eager to learn. FM ver 11

My tables contain a Parent table that's connected to a Child table in a one to many relationship.

The Parent table will always contain only 1 single record.

I have created a separate layout (list view) for the Child records. When I create a new child record in this layout I want to populate the field fk_parentID with the ID of the Parent table, field PK_parent ID.

I don't want to use a portal for reasons that relate to layout functionality shortcomings.