Reply to comment

Certain fields are never editable directly. These include the five built-in fields, all formula fields, and all lookup fields. In addition fields that were at one time reference fields can behave in such a way that they don't display either a read-only or an editable value. Here is the situation that creates these former uneditable reference fields.

You have two tables in a master-detail relationship. You delete the master table without first deleting the relationship. Then the reference field in the detail table still thinks its a reference field. So if you put this former reference field on an edit form you can't get it to display as an editable control. QuickBase is trying to display the field using the record picker. But the master table doesn't exist so it can't build a record picker so it displays nothing at all.

To workaround this attempt to delete the reference field. When you try this, QuickBase decides that it won't let you because the field is part of a relationship. It then offers you a link to edit the relationship. If you click on the link you see a half existent relationship. Click on the delete relationship button. Accept the confirmation dialogs. This will remove the pointer in the reference field pointing to the nonexistent master table. Now the reference field is no longer treated like a reference field and will display on edit forms normally.

Reply

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit