Hi Bill.
Just my comments from experience using the 'Set Filter' , prticulalrly on forms.

I've used this technique extensively in 2.6, but have noticed in VFP7/8, that it can be extremely sssssslow if used on a form, particulalry acoss a network. By sssssslow I mean, having to wait 3 minutes on a Goto Top command for a file which ha a filter (with an index). Prior to VFP7/8, it took seconds.

I dont know why this is an nobody has been able to give me satifactory answers..... but just a word of caution

I've ended up replacing my Set Filters to Seelcting out into a cursor.. solved the problem but meant a lot of recoding

Regards,

Gerard






>Am working with vfp7.1 and Win XP.
>Want to build a "filter by" form to enable the user to filter a table (part of a DBC) in a number of ways. All of them are fields in the table except one.
>That is a "Grouping" table that contains all the record ID's for each group. The records can be part of more than one grouping, so there is no field in the actual table containing the group ID.
> The groupings (names & descriptions) themselves can also be added to, edited, and deleted by the user.
>
>The question is:
>How can I filter the table using the regular "set filter to" expression, but also include records that are included in a particulat grouping (that also match the other filter requirements)?
>
>All help appreciated.
>Bill Wright