I would like to be able to insert records into multiple tables of one database....

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I would like to be able to insert records into multiple tables of one database....


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I am familar with Access and this can be accomplished by developing a querry (or view depending on your jargon). Develope the querry that joins the multiple tables, make sure the primary or secondary keys for the tables are in the query (you do not have to list them in the screen your are using for data input or update). Failure to do so may result in a "too many row return error". Once the person has changed or updated the record all that is needed us the update function on the screen to submit or commit the data. The last thing to remember is make sure that the querry has the rights granted to it so that it is allow to update the records... if it is in a read only state, then the commit will fail. Sorry for being wordy, but sometimes more information is better.

Kent

Wm. Kent Steelman