Looking Up Multi Select Text Field from A Relationship

You will need to add a new lookup field for the Parent into the child, and then look for all usage of the previous lookup field and replace it on reports and forms and possibly formulas with the new field. Then check that the old lookup field is longer being used anywhere and delete it.

It would be helpful to rename your current lookup field to old lookup field, so the new one can have the good name.

Thanks Mark. 

Mark

Going back to this.  I might have resolved it back then but don't seem to understand.  Are  you saying that I delete the look up and add back to get the multi select field working?  I have a similar issue now.  

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.

Thanks.  It was resolved.  Now there is a little twist there.  If I have a report  in which using a filter that show me all projects where 'Store Type' is blank, it worked.  But after changing this field to multi select and adding back to the report (as it was deleted), I cannot seem to find a way to filter the report based on multi select field.   

I'm guessing that the multi select lookup field comes down looking like

apples; peaches; pears

ie a semi colon delimited text field.

The user can use the filter box at the top to type in a type of fruit or else you would need to make a series of formula checkbox fields to calculate of the fruit contains "apple".  So a field called
Apple Yes / no
Peaches Yes / no
Pears Yes/no

But you only get 5 Dynamic filters per reports so it will work if there are less that 5 type of fruits (Stores)    

The low tech solution is to put in a report description to explain to users what to type 

Also you can explain that typing apples OR Pears with the OR in upper case will get hits on both apples and pears.  The OR has to be in upper case.  Also AND in upper case will work too but as an AND.

Mark

Thanks.  I am actually trying to run a report with multi select field as the filter to show all records where it is not blank. This keeps on showing all records.   

Have you put that field on the report to see what the data looks like?  I'm sure that the field is not blank, and hence is on the report.

I would have to look at your app or do some testing to verify that as it seems unlikely.

Support desk have advised that this could be a bug.  They need to review this.