>Josh told me that although "SELECT .... UNION SELECT ...." can join the result of two tables but it couldn't help to insert a record to two tables. I tried to insert a record to a view which was created by 'SELECT .... UNION SELECT ...'. When I insert a record, both of the tables could be inserted except the keyfield. Although I used "CURSORSETPROP" to set the keyfield updatable, I couldn't input the data to the tables.
>
>Is there a way to insert multiple tables with a simple command(s)?
>
>Sunny
Are you using a view that is created from two or more tables? If so, then you have to use the DBSETPROP function instead of the CURSORSETPROP. The two have mostly identical properties. There is an excellent example in the the Developer's Guide (Updating Multiple Tables in a View, page 202).