Page 1 of 1

Inserting data into multiple Table

Posted: Tue Jan 19, 2010 5:55 am
by pavanesh2009
Hello Everyone!!

I need to insert data into three table through single submission of a form,(obviously table are related to each other), Please suggest how I can make out this?

Thanks in Advance!!

Re: Inserting data into multiple Table

Posted: Tue Jan 19, 2010 1:08 pm
by McInfo
Use three queries.

Edit: This post was recovered from search engine cache.

Re: Inserting data into multiple Table

Posted: Tue Jan 19, 2010 2:57 pm
by tr0gd0rr
Also you may want to use a transaction around the 3 queries.