>Hi!
>
>Whats the best way of filtering whats in a grid? Say you have a grid based on a table, and you have another field which is a date field. Based on the date the enter you want to filter for that date on the grid.
>
>At the moment im using the set filter command but this seems a bot clumsy?
>
>Many thanks in advance
>
>RC
>Bespoke Software Systems
Robin,
Filter is a choice but when it's grids not a good one.
Other options off the top of my head :
1) Set key to (considering you have index on date or combination including it)
2) Parametric view (might be created on the fly)
3) SQL recordsource (again requires index)
4) SQL select
Cetin