I've created a site using the Site Assistant. This database is managing more then 500000 records and I want to stop people doing a search when the search fields are blank.

When this happens it takes loads of time to return a result because it is finding all records. Is there a way to stop this.

Or

This database has many differnt access names (one for each client), is there a way to tell it to only find the records applicable to the person who's logged in?

I think my 2nd request would be better so that the find can be a kind of "find all" option. But what ever is easier.

Any help!

With respect to the empty field problem, there are two possible solutions:

- add Javascript code that checks the field. However, because this is client-side, this can be bypassed (e.g. by turning Javascript off, or by downloading the form page and modifying it).

e.g. you have a field query that has to be checked, then the JavaScript code could look like this:

and the form must be modified like this:

- another, more secure way is to check the field server-side before the query is submitted. This, however, involves some sort of intermediate database.