>>Thanks, Mark, for your response.
>>
>>I should have mentioned that this is a modification from a database of free tables that is still being manipulated by an FPW26 app. IIRC, views don't work with free tables.
>>
>>How might it be handled using free tables?
>>
>
>Create a DBC, then create a connection using the VFP ODBC driver. Specify the data source is a free table. Select the free table. Create a remote view to the table using that connection.
>
>No way would I use VFP to directly interact with production tables still in use by a FPW2.x app. You could accidently render them inaccessible from the 2.x app by converting them to VFP tables.

Unfortunately, that is the way much of the existing work was done by a previous programmer. I have considered incorporating them into a dbc for several reasons, but haven't gotten around to it yet.

I presume the SQL statement would be tied to the rowsource property of the grid itself? Also, I'm not sure why you recommend the parameterized invoice number. Couldn't the orderID (same thing) be part of the SQL statement?

Neil