Rick Whitelaw Posted March 8, 2015 Share Posted March 8, 2015 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3330 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now