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
Can you live without the earth?
Please remind that :
"Yung Hung" is my first name;
"Yeung" is my last/family name.