I am trying to set an dropdown object on my page for which the list of items in the dropdown is conditional on a database field containing a value or not.
For example, I have a table of Golf Courses. Each course has values for rating and slope (2 numeric fields). Normally, there is a rating for each tee off colour (Blue, White, Gold, Red). So I have Blue_rating and Blue_slope fields, White_rating and White_slope fields, etc…
But not all golf courses have Blue, White, Gold and Red tee-offs. Therefore, some fields for a specific golf course may contain no value.
My Dropdown field on my page would show only those Tee Off colours for which there is a rating/slope value in it.
Sorry for the long explanation… I’ll keep imagining a solution in the meantime.