I’m sure this is easy for someone, but not me: I have a table (RESULTS) that lists all results by the driver name, event and their results. I made a virtual column (DRIVER RESULTS) in that table that gives me a concatenated text string - for instance (2015 Seafair: 1st Place) for each entry so I now have a pretty text string I can use.
In the DRIVERS table, I have the drivers listed by name (only 13 of them), and all I want to do is get the (DRIVER’S RESULTS) list from the RESULTS table to the DRIVERS table as a column I can display.
I can get a comma delimited list of row numbers, but I cannot get the (DRIVER RESULTS) text. Also, if I CAN get the DRIVER RESULTS
list to show up, how do I get the entries as individual lines instead of comma delimited?
In other words, i need to have the ability to list a driver’s bio info, then a list of all of their finishes in the bottom of a detail view as a list and not a string of text separated by commas…
I am completely confused at how to do this!!!
Can anyone give me some ideas?