kinglozzer

I’ll spend 5 minutes googling a subselect and if I don’t find anything, has_one Year it is 😛

dorsetdigital

So that could take a pounding... don't want lots of loops or subqueries really

dorsetdigital

Especially if this is a front-end function (eg. filtering parts by model year)

dorsetdigital

You might even be better off maintaining a table of model years

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?