Hi I was wondering if anyone could help, I am struggling to get workflows and Select functions to show the Label column instead of the Key Column.
Basically I have 3 tables:
- Vehicle Movements
- Driver List
- Driver Training
Both the Vehicle Movements and Driver Training tables are Ref via the Driver Name column to the Driver List table. I am able to show an inline view of the Related Training by using [Driver Name].[Related Driver Training] which works fine however I am looking to get this in a single string separated by commas.
Whenever I try this using the SELECT or LIST functions it will return the Unique ID instead of the Training Course column which is set as the label, the same happens when sending an email via Workflows.
I am sure there is an easy way around this and I am certain I have done it in other apps previously but for some reason I cannot figure out where I am going wrong!
Thanks in advance.