>> For the grid you need to set the columncount to the number of fields you want in the grid and then you need to set the controlsource property to a field in your table for each column in the grid. This way you display only the fields you want and in the order you want also.
>>
>>Mark
>
>Is there a way to do this without columns?
Here's a quick'n'dirty way:
grid.columncount=-1
grid.init:
select (the_alias)
set fields to all like * except [insert name of field to omit here]
this.recordsource=the_alias
Tried, works. You may want to set fields to ALL elsewhere, because with SET FIELDS the field is not invisible to grid only, but to the rest of the app, too. You may also overcome this opening The_alias once more with all the fields, and keeping them in sync.