Hi,
wondering if I can set the qualification of a table field dynamically based on what character fields are selected on the form?
I would like to have a table refine what is displayed based on a number of selections made by the user from Character boxes.

eg. I have 3 character fields and a table. When character field one is selected, the table showa all assoicated entries. When field one and two are selected, the table shows entries based on the 2 selected fields and so on for the other selections basically refining the list as the character boxes are filled.

I currently have it only showing anything if all the associated character boxes have an entry in them.

Current qualification for table is:
'field1' = $field1$ AND 'field2' = $field2$ AND 'field3' = $field3$

Regards
Carl

Try:


('field1' = $field1$ OR $field1$ = " ") AND ('field2' = $field2$ OR $field2$ = " ") AND ('field3' = $field3$ OR $field3$ = " ")

Also have a look at:
EXTERNAL()
Here you can build the qualification in a (say temp) field and reference it

I use to create a form Called SHR:Menu and then one of the fields will be External Qualification. This way each and every Menu item/entry has the potential to have it's own qualification. I like Generic code :-p

Thanks guys,
the OR " " works a treat, but can also see the value of an External qualification.

Cheers, appreciate it

Carl