Hello everyone,
This is my first time writing to this forum and I am very happy to have found this resource! I need some help with the syntax for a program I am working on.
I have a grid that pulls records from "tableA" and would like to have the information that is updated on the grid inserted into another table "tableB" without overwriting existing records from "tableA". I have tried using "Append from" in the SQL but Fox Pro won't accept it. How can this be performed?

Here's the SQL I use:
SELECT * ;
APPEND FROM tableA;
ORDER BY tableA.fieldA;
INTO TABLE tableB

Also how can I have messages automatically responed to? For example when a message box appears with yes or no response buttons how can I make it automatically select "yes" so the process is not stopped and no user input is required? The return value should be 6 but how do I implement code to make the form choose it?

Thanks in advance for your help!
Max