Forum Discussion
QuickBaseCoachD
Qrew Captain
You cannot edit a lookup field type. The closest you could come to that would be to have an override field and then a final firmula field to use the override field if not null /blank or else the lookup field.
AlexCertificati
6 years agoQrew Cadet
Promo table fields
[HD Item - Master Item - HD - Model Number] type: lookup (no change)
[HD Item - Master Item - HD - Model Number ENTRY] type: user input
[HD Item - Master Item - HD - Model Number FINAL] type: formula
lookup field is as it is today - including relationship to parent table
user input field allows your user to enter data on your grid edit report
formula field is the one used in reports/other calculations/etc
Write the formula on the formula field such that, if there's a value in the ENTRY field, use that, else use the value in the lookup field (which is still drawn from the parent record), thus preserving the relationship.
[HD Item - Master Item - HD - Model Number] type: lookup (no change)
[HD Item - Master Item - HD - Model Number ENTRY] type: user input
[HD Item - Master Item - HD - Model Number FINAL] type: formula
lookup field is as it is today - including relationship to parent table
user input field allows your user to enter data on your grid edit report
formula field is the one used in reports/other calculations/etc
Write the formula on the formula field such that, if there's a value in the ENTRY field, use that, else use the value in the lookup field (which is still drawn from the parent record), thus preserving the relationship.