Populating FK in Child Table. Doh!

[Rick Whitelaw]

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. 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.

Post a new Answer