Hello

I have a situtation where I would like to create a query screen that allows the user to search a subset of a database. Right now the subset is accessed through a canned query or stored search, but as the list is getting larger, we feel it would be easier for the user to search the contents, rather than scroll through it.

Any suggestions please?

You could add a new field (eg. name it "Subset"), run your canned query in the desktop and then batch modify the records so that the new field has the same value (eg. "Yes" )

You would then add the field as a hidden field on your query screen to return only those records.

<INPUT NAME="QB10" TYPE="hidden" VALUE="AND">
<INPUT NAME="QF10" TYPE="hidden" VALUE="Subset">
<INPUT NAME="QI10" TYPE="hidden" VALUE="Yes">

Your user could then run searchs within just those records eg. where author is smith and year is 2007 and subset is yes.

We use this to not show items that are In Process

eg.

<INPUT NAME="QB10" TYPE="hidden" VALUE="NOT">
<INPUT NAME="QF10" TYPE="hidden" VALUE="In Progress">
<INPUT NAME="QI10" TYPE="hidden" VALUE="Yes">

This message has been edited. Last edited by: JennM,

You could use Record Level Security on a Silent Password to hide all the records except those in your subset.

It's essentially the same setup: you batch modify the Access Control field for the records in the subset to contain the class that permits user with the Silent Password to see the record.

But you don't need to modify your query screen, and See Also search links will also exclude records not in your subset.

Many thanks for both suggestions. I have taken a few steps towards trying one - addign the Subset field , and designating it a hidden field, but that has lead me to another question.

How to include the instructions JennM mentioned in her posting - namely the following:

<INPUT NAME="QB10" TYPE="hidden" VALUE="AND">
<INPUT NAME="QF10" TYPE="hidden" VALUE="Subset">
<INPUT NAME="QI10" TYPE="hidden" VALUE="Yes">

I think I am missing a few steps in trying to implement this, as all attempts so far have not worked.

After you use Export Query Screen to HTML in the Query Screen Designer, you would open the HTML file in Notepad, or another text editor, and add the lines shown immediately under the last set of QBxx/QFxx/QIxx tags.

And the number after the QB/QF/QI tags will depend on the number of fields you are searching. When you open the query screen in notepad you will see the highest number for the last field you included in your search. Just make sure your number is higher than that last number. It cannot be the same.

In my example I gave it as QB10, QF10 and QI10.