Forum Discussion

JenniferJennif1's avatar
JenniferJennif1
Qrew Trainee
8 years ago

Capture value of field from related table, but only at that moment

I have a parent table called Requests with a field called Status. I have a related table called Log with a field called Log Status. At the time I create a new record in Log I want to capture the cu...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
No Problem.  Quick Base anticipated your need.  You already have a lookup field called [Status].  For clarity, rename it to be called [Status (lookup)] .

The create a new text field called [Status (snapshot)].  Way down at the bottom of the form properties you can specify it to get its value for that lookup field and freeze it.  (ie take a frozen snapshot of it at the time the lookup was  first populated.