>>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?
>

Yes, I was just guessing at the parameter you would use. The remote view would be a permanent object in the DBC. Yes, the RecordSource of the grid would be that view.