>I fyou want to select allrecords with all fields then use
>SELECT * FROM table INTO CURSOR 'name'
>Mark

I am actually creating a view with parameters. However, when using views, you can "USE myview NODATA". How can you do someything like "USE myview WITHALLDATA"?

I let the user narrow the results from there. The table only contains around 200 records. The user will usually narrow his search by entering values into a column and REQUERY().

Thanks,

Jerryt