AnsweredAssumed Answered

Write 1st Related Child Record and Auto Set Key Fields

Question asked by hoffmanjan@umkc.edu on Jan 15, 2013
Latest reply on Jun 26, 2018 by philmodjunk

Title

Write 1st Related Child Record and Auto Set Key Fields

Post

     I use FileMaker Pro 11.  I have a ParentTable with an IDNumber as unique key.  IDNumber is fingerprinted by the user in initial creation of a ParentTable record and should never need the user to input again.  ChildTable is related to Parent Table by IDNumber as one to many.

     My question:  How do I write the initial 1st record in ChildTable without forcing the IDNumber to be typed in by the user?  There might be multiple ChildTable records with the IDNumber or there might not be any records.  New Record Request requires input from the user.  I need to set ChildTable::IDNumber to the value of ParentTable::IDNumber and automatically populate in the ChildTable.  Never will a ChildTable record exist without it's related ParentTable record.

     Thx,

     JanH

Outcomes