Set filter the alias which the grid dispaly record.

Set filter to Command.

Aashish


>Is there any way to have a grid show records only when a certain field within the table linked to it matches a condition? I do not want to use sql or views, is there any simple way to do this with a regular grid object associated with a table?
>
>Kev
Aashish

You better believe in yourself... if you don't, who else will ?

Thanks Aashish,

The SET FILTER TO command worked well. I tried to filter within the grid itself before and it never worked right. Grids are a funky kinda animal to work with. I never thought about doing it at the table level. This method works very well also because it uses the rushmore technology if part of the expression in using a field that has an index associated with it, and it also evaluates the expression as the record pointer hits, not at load time, so it is very efficient to use.

Thanks Again