kinglozzer

Vehicle 1: 1990 - 1992 Vehicle 2: 2000 - 2001

Dropdown needs: 1990, 1991, 1992, 2000, 2001

wmk

But won't that be a dropdown from e.g. 1980 to 2020 anyway after some records?

kinglozzer

Yeah, but I’ll have to run that for every record 😛

kinglozzer

If I have a vehicle which is 1990 - 1992 , I need the dropdown to include 1991 as an option

kinglozzer

Come to think of it, that’s going to be a problem with distinct and group by 😕

null

it's going to be some custom SQL query, like SELECT Year FROM ... WHERE (...run some subquery...)