I'm having trouble writing the code to insert data into multiple recordsets. I have used the "Insert Record" command to insert the data into one table, but there are 2 other tables I need to add information into. I tried to handwrite the code using the recordsets that Ultradev created, but apparently I don't understand the code that Ultradev generates enough.

If anyone can help me with this I would greatly appreciate it!

Thanks,

Clanggedin

Ultradev doesn't support inserting into multiple tables so you have to handcode it.
There's a very cool example at charon.co.uk/UltradevDownloads_UD4.asp "Update Multiple Tables", thanks to Jules <img src=icon_smile.gif border=0 align=middle>.

Waldo Smeets - www.UDzone.com Webmaster
------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
------------------------------------------

Thanks, Waldo. I checked that out and it was pretty confusing.

I figured that If I create the recordsets in Ultradev and add this code under the recordsets it works.

&lt;%
Recordset1.Addnew
Recordset1.Fields.Item("Count".Value = "YOUR TEXT HERE"
Recordset1.Update
%&gt;

works like a charm!

Hi,

Why can't we we use recordset.Insert here?
What we are doing here is a insert, Am I wright?

How to insert, update or delete from muliple tables from one form/page: www.drdev.net/article01.htm

Regards

Owen.

-------------------------------------------------------------------------------------------
Used programming books and web development software for sale (UK only): www.tdsf.co.uk/tdsfdemo/Shop.htm

Developer services and tutorials: www.drdev.net

Multiple Parameter UD4 / Access 2000 Search Tutorial: www.tdsf.co.uk/tdsfdemo/