Forum Discussion

ArshadKhwaja's avatar
ArshadKhwaja
Qrew Commander
8 years ago

Looking Up Multi Select Text Field from A Relationship

I have a one to many relationship and I had a look up text value in the child field.  However, recently when I had to convert the parent field to multi select field, I received an error in the child t...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Right, if the parent was say any field type - say numeric and it was looked up to the child as a numeric lookup.  Then you change the field type of the parent to say a text field, then the child table lookup field will get broken. 

You need to look it up again, and then use the usage table on the broken field to locate all uses of the broken field in the child table,  and replace it with the new lookup field and then finally tidy up by deleting the broken field when it is not used anywhere.