When a 'list' item, how to get beyond 'array' in Search Results page?
All my lookup tables, bar one, are 'menus.' When searching in the database, these items show up in the results with the entry for each record. So satisfying.
However, one of my lookup tables necessarily must be a 'list' - multiple values are possible. The menu works nicely in Insert / Update. However, the output for that menu item on the Results page is always 'array.'
May I learn, in my newbinesss, how to deal with this? Is there a way to see multiple results, for instance, or just one if there is only one in that particular record. Or perhaps, some sort of actual array in the results page, indicating what has been selected and what not?
Then of course, there is the question of how to use the outcome, in a binding on a page …
Probably too late tonight, so maybe let's do this Monday.
Thanks, David