How To Save From 1 Table to another??

[budaksaiko]

im so desperate right now.. my dateline is just around the corner.. and im stuck at this sevral problem.. and please if anyone could help me out with this matter.. please help me so.. *wink

my problem is.. i tried to save data from different table.. i.e i have this table named coursedetails where i stored all the newly registerd courses. in a form named X let say. then, in Form Y, i wanted to add staff to that course that i just registerd in form X. in Form Y, i put all the courses details calling from the coursedetails table where each data will be displayed using the rs format (i.e <%=rs("coursecategory")%>). then in the same form Y, there is details that is needed to be entered by user like the staff data who will registered to that course. after keyin the particulars, i will save the data and instead i put it to coursedetails table(which is a temporary table to hold for new empty course, no data for staff details in this table), i wanted to save to staffdetails table, but the problem is it wont save. it work with saving data from same table to same table but not this one. how can i tackle this matter??
im so confused.. im using asp vbscript for this web system.

thank you.

[kaihirst]

Hi,

I have now read this three time adn still I am not understanding what exactly you mean. I understand what youre tyryig to do but I ned a explanation to this effect.

So youve got 2 forms, 1 saves course details and the other saves staff detaisl, but they both sometimes save the same information? or is it completely different, and you need the same information from each of the forms into the both tables?

A better explanation is needed please before any solutions could be entered into.

Cheers

Kai

[budaksaiko]

im sorry if i make anyone reading this thread rather confused. just like me..he.. .
okay then. i try to explain as good as i can.

i have this form called course register where i would register any new course my company find useful for the staff to attend. i save this to me a pre course register (cause there is no data about staff who will attend this course yet, only the course details)into a table i named as coursedetails.

then, there will be form listing all the new courses available. and once i click on any of the course (there would be a link at the course name to open another form) to register staff to that course, form named new course register will be displayed.

in this form, it will auto display details of the selected courses. plus new filed added to be added by the user. the new details are the the details of the staff who will be registering to that chosen courses.

my problem is, i want to save this details into staffdetails, another table instead of coursedetails. because staffdetails is the main table where i stored all details of the staff and courses that they had attended.

yes, both table will have the same details except that staffdetails will have extra information on the staff details who will be attending the selected course. its like copying details in coursedetails into staffdetails.that is what i intend to do. i had tried, and evrytime i click on save, it just dont work.how can i make this possible??

thank you.

[noielen]

can you show/post your code? save code? your problem is to save? ryt? post your code plz...

i think the fields that you'r going to used in staffdetails are
- key/unique field in coursedetail
- plus new filed added to be added by the user

staffdetails must have also a unique/key field

ex.
CD001 = key/unique field in coursedetail
Field1 = new field 1 staffdetail - key/unique
Field2 = new field 2 staffdetail
.
.
.
Field10 = new field 10 staffdetail

hop u nderstand!

[noielen]

ther's an error? what is the error? explain more...