Reference qualifier to limit choice

[eileenhessmille]

I want the user to be able to select specific choices for a reference field.   Our company table contains hundreds of records, but I want to show just 6 of them in the dropdown on a form. I got it to diplay one, but I don't know how to format for a list.

Reference qual:   name=comany1

I want company1 through company7 to be available in the dropdown.

Thanks!

[Mark Stanger]

Again, you need to be able to filter on these in the UI.   Start there and create a filter in the list to just show the companies you're interested in.   Then you can copy the query and use that for your reference qualifier.

[eileenhessmille · Accepted solution]

So what we ended up doing was to add a flag to the company table, default it to false, then go into the very few records that I want to diplay and set those to true.   Then add the reference qualifier as flag=true.