insert form please help this beginner

[Johnny23]

i have created one insert form using interdev 4
but i need it to insert records into 2 different tables from thisa one form in my SQL7 database and i cant get it to do this???
help anyone???

Idunno what you mean with an insert form in InterDev 4, but if you get the data you want, and submit the form, then in the page the "action" points to, you can just write the data to as many tables as you wish using separate insert statements, right?

Maybe I'm thinking too simple, or am not fully understanding the question. Could you try to explain it a bit more?

Marcel

[Johnny23]

ok im using ultradev 4
and have created a form on mypage.asp
with about 15 diffrerent textbox fields of which
they relate to about 3 differnet tables in the database.
i want to create an insert to insert the records from this form into the three different tables
called

USERS
MANAGERS
CLIENTS
i an get my form when clicked on the submit button to submit all the data entered into the usrs table but
when i try to put managers into it i always get an error
soemthing about only one table permitted per form per page...
so how do i get it to submit all my info !!
also in my SQL7 database
my table USERS the first field is
userID and is a primary key field and does not allow nulls how do i get it to autoincrement a new number everytime i add a new recoerd from within an asppage

Hi again,

To tackle your last problem first: make sure the Datatype of the field is numeric, uncheck the Allow Nulls field, and check the Identity field. I'm not 100% sure if you also need to indicate the field as the only key value (by putting the key symbol in front of this row) but it won't hurt to do so.

Still not too clear about the inserting problem. You don't write the insert statements yourself, but let UltraDev take care of that for you, is that what you're saying? Coz if you wrote them yourself, you should be able to insert data into as many tables as you wish.

Unless you try to insert data into several tables at the same time, using only 1 insert statement. I don't think that will work. Just create 3 different insert statements for the 3 different tables and you should be alright. If not, send me the code and tabledefinitions and I'll write the code for you, so you can see if that will work, okay? (Send it to me by email)

Good luck!

Marcel