Forum Discussion

JamesTrory's avatar
JamesTrory
Qrew Assistant Captain
7 years ago

Stop a lookup field being modified in the child table when it is modified in the parent table?

How can I stop a lookup field being modified in the child table when it is modified in the parent table? I have two tables, Talent and Assignments (a one-to-many relationship). One Talent can have ...
App builders
Forms
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
np
Change the name of the [Day Rate] field to be called [Day Rate (lookup)]

Then make a new field called [Day Rate] and set that to be a snapshot field of the [Date Rate (lookup)] field.

ie the snapshot field is a separate field from the lookup field.