Stamping Parent Record Field Upon First Child Record Being Created.

Question

Greetings Quickbase!I have two related tables, Loan Records and Submission Records, where the Loan Records table is the Parent and the Submissions table is the child(1 Loan Record can have many Submissions.)  What I need to do is uniquely identify the FIRST Submission Record connected to a Loan Record APART from the following Submissions created afterwards connected to that same Loan Record.For example:Submission     Date Created   MarkedSubmission1     10/11                YesSubmission2     10/12                NoSubmission3     10/13                No             Submission4     10/14                NoAny suggestions would be greatly appreciated.Thanks in advance!Cheers,Nate

ArchiveUser · Answer

You can do this by using a combination of Summary, Lookup, and Formula fields.

Create a Summary field from the Submissions to the Loans, using the Minimum function on the Record ID# field. This will give you the Record ID# of the 1st Submission record.
Create a Lookup field from the Loans to the Submissions, bringing down the Summary field you just created in Step 1.
Create a Formula Checkbox field on the Submissions table with this formula: [Lookup]=[Record ID#]

Sign up

Login to the community