>If a run a query on a table to select all of the records and then append a new record to the original table is there a quick way to include it in the already exisiting query, or do I have to redo the whole query?
>
>Thanks
>Matthew
No you don't have to redo the query. Assuming that the result of the query is in the current work area:
lcfile = DBF()
SELECT 0
USE (lcfile) AGAIN ALIAS Whatever
Now you can modify the result set, add records, etc.
hth,
George
Ubi caritas et amor, deus ibi est