AnsweredAssumed Answered

Populating FK in child table. Can't believe I didn't know this!

Question asked by RickWhitelaw on Mar 7, 2015
Latest reply on Mar 7, 2015 by philmodjunk

Title

Populating FK in child table. Can't believe I didn't know this!

Post

When creating a record in a child table on a layout based on the child table ( which has to inherit the PK of the parent table) I figured out that there's a simple way that I just discovered. I've used FM for ages and never saw this. On the child layout create a field Child::FK which contains the foreign key of the child table. Make that field get its values from a value list defined as Parent::PK which shows the Parent PK values plus a second field. Say Name. Uncheck show only related etc. now when a value is selected the Child::FK is successfully populated with a proper match. Doh! An easy fix. I can't believe I never saw this before. Or maybe I did but forgot. Seems like a basic technique.

Outcomes