>I am updating some data in a Grid. I want to append the data from the Grid or View to a Table. How do I do this? APPEND FROM and INSERT INTO doesn't seem to work on views. I don't have a clue as how to send the data to a table from a grid if you even do that.
>
>
>Thanks
Easiest way is to use a parameterized view as the grid source. Then when the updates are complete you do a TableUpdate() and all the information is done for you.
If you are Adding records to the grid recordsource, you will need to be sure you have the correct primary and foreign keys to update the base tables.
HTH
Barbara