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