Reference qualifier to limit choice

eileenhessmille · ‎08-07-2014

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!

eileenhessmille · ‎08-07-2014

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.

View solution in original post

Mark Stanger · ‎08-07-2014

What do each of those companies have in common? If you can set up a filter in that list to just show those 7 companies you can right-click the filter breadcrumb you end up with and copy the query from there. That will be the reference qualifier you need to use.

eileenhessmille · ‎08-07-2014

The companies have nothing unique in common from the other records. It could easily be a choice list, but the requirement is to use a reference.

So, if the records happen to be a through z, but the records to be included in the dropdown are c,h, and u, is there a way to specify only those records in the reference qualifier?

I've tried name=c or h or u

and name = c|h|u

and name is one of c,h,u

but, they didn't work. I don't know if that's a legitimate way to use the reference qualifier field on the dictionary.

adiddigi · ‎08-07-2014

for two companes 2 and 3 com the below is the ref qual:

name=2^ORname=3Com

so for the compaines c, h or u

it's going to be name=c^ORname=h^ORname=u

sbungener · ‎10-30-2014

Hi, just a quick question on this.

Does this also work with AND??

So like filter out records, name=c^ANDname=h^ANDname=u

Is have something similar, but it does not work