Conditional value list returns values & "?"
I have two tables: Loads and Vehicles
Loads contains a list of dates and a list of vehicles IDs. There is a relationship between the two based on the Vehicle ID.
I want to count the number of days a vehicle runs for, but as it might do anything from 1-4 loads per day (also 0 loads, but then there would be no load record) I need to count only unique instances.
I have created a value list a conditional value list, starting from Vehicles that lists all the delivery dates.
But when I test this value list from the Vehicles table, it contains some of the dates, but not all, and the last value is always a "?"