Hi, I have a table with Cars and names of drivers who can drive it (simplified example). The Driver are picked from a a reference list on a separate table used as Enumlist in the app, hence multiple people can be drivers of a certain car.
I would like to create a reference where I can see what cars the drivers can drive. I can only make the reference match work if there is one driver per car. Can you help me understand how I can use certain part of the string to make the reference matching. I am by no mean a coder (as you probably can tell…)