Search over multiple fields of subform data
I have a list showing the data from the subforms. I have several fields from the subforms showing. I am concatenating the fields from the subform so they can all be seen on the view. When I search I only get matches against the first field in the list of fields that are concatenated.
eg. main form has name, sub-form has age-band and location. If a row shows "Martin" for name and "London 0-10 11-20" and I search for contains "0-10" I receive zero matches.