Forum Discussion

SalesInfo's avatar
SalesInfo
Qrew Assistant Captain
6 years ago

How to make a lookup field editable on the embedded grid report?

I added a report link field to display a grid report so I can easily add multiple records for another table. The problem is there is a field (see below) on the report, which is a look up from another ...
APIs and custom code
Forms
NotificationsEmail
QuickBaseCoachD's avatar
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.
SalesInfo's avatar
SalesInfo
Qrew Assistant Captain
6 years ago
The problem is that if I create an override field, there will be no relationship between the Promo (child table) and HD (parent table) when I add a grid record on the form on Promo table. 

Is there a way that I can link them?

Thank you!