prevent application of filters that pull WAY too many records to the client

[Jesse Aufiero]

I've created a form in 'single form view' for users. The form always opens
with a filter to greatly limit the number of records that are returned to
the client. However, I'd like the users to be able to modify the filter
criteria using 'Filter by Form' to access other underlying records that
aren't accessible via the initial filter, but I DO NOT want the user to be
able to clear ALL filter criteria, because I don't want the users to be able
to pull all records to the client. Is there a way to allow filtering by
form, but prevent the clearing of all filter criteria? Or to somehow
prevent the application of a filter that pulls over X number of records?

 

[Guest]

Jesse,

I don't know whether or not the programmer has access to the FilterByForm
tool to prevent clearing the filter, but you could easily build your own and
prevent the clearing.

You don't mention *why* you wish to limit the number of records. If it is
to limit network traffic, I can't think of a way to limit them prior to
applying the filter. However, if it's for some other reason such as limiting
the number of locked records so that they're available for edit by others,
you can apply the filter first, check the RecordCount, and display a "The
filter returns over x records. Please apply a finer filter." message, and
allow the user to fine-tune it.

Hope that helps.
Sprinks