Forum Discussion

NateElme's avatar
NateElme
Qrew Trainee
8 years ago

Stamping Parent Record Field Upon First Child Record Being Created.

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 Su...
ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago
You can do this by using a combination of Summary, Lookup, and Formula fields.

  1. 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.
  2. Create a Lookup field from the Loans to the Submissions, bringing down the Summary field you just created in Step 1.
  3. Create a Formula Checkbox field on the Submissions table with this formula: [Lookup]=[Record ID#]