hello, i am a BSIT student. and I'm working with my thesis. I have a problem in inserting a mutiple record using one form into a multiple table in the database. I'm using a Dreamweaver8 for the design and a SQL2000 for the database. What should I do??? If im inserting a multiple record, and I have something to do with the code. where should i put it??? in the SQL or in the dreamweaver??? somebody help!!! SOS!!! Thank you a lot lot lot!!!

rayp.reloj

Hi Ray,
this may sound a little harsh, but . . . what have you done to solve this before asking others? What did you search google for and what response did you get?

What kind of records are you trying to insert? The information you supply is very limited so the people who read it will not be able to give exact answers.

try a quick search for something like 'insert multiple records sql' without the quotes and see what comes up, my guess is that there will be tutorials and even some code. I used to mark student work - what I would be looking for is evidence about how you solved the problems that you encountered and what you did to solve them, references to your sources would get you bonus points.

elow.... ahh I wrote a wrong topic... I mean inserting a record into a multiple table in a SQL2000..
I have also a problem bout its relationship.. unlike Microsoft access you cannot view its relationship.. I can put a relationship between two tables but i can't see its relation. unlike ACCESS you can see its data with a relationship with the other table...
somebody said that it is not possible to insert a record into a multiple table in the database.. if its impossible, how can I insert a record into a multiple record using 1 form... can you help me??? thank you very much for your response... its really really a big help for me... I wish you can help me with this problem... We have a defense, we will defend our system for us to pass our course... thnx again....


rayp.reloj

hello ray, this may be of help:

www.charon.co.uk/download_details.aspx?a=117

.