hi i'm writing some asp pages for capture inforamtion from an access '97 

database on a server and updated via forms. i can write forms to allo 

inforamtion to update one table per form. is it possible to have a form 

that has information from more than 1 table from a database and when the 

submit button is pressed that both talbes are updated.



any help would be gratefully received.



cheers

karl. 

Prefix the form field names with "tablename_" so that when you retrieve the

fields in asp

you can know to which table they belong to.



Its just a matter of common sense. You can use any kind of logic  you want.



----sathish kumar, R

sathish297@y...



----- Original Message -----

From: "karl hammett" <karl.hammett@b...>

To: "Access ASP" <access_asp@p...>

Sent: Wednesday, November 28, 2001 10:30 AM

Subject: [access_asp] double entry forms





> hi i'm writing some asp pages for capture inforamtion from an access '97

> database on a server and updated via forms. i can write forms to allo

> inforamtion to update one table per form. is it possible to have a form

> that has information from more than 1 table from a database and when the

> submit button is pressed that both talbes are updated.

>

> any help would be gratefully received.

>

> cheers

> karl.




>

> Read the future with ebooks at B&N

>

http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid

=rn_ebooks







_________________________________________________________



Do You Yahoo!?



Get your free @yahoo.com address at http://mail.yahoo.com

 hi sathish 



i'm not sure i explained the exact problem. 

i can get data from more than i table on a form, but when the submit

button is pressed and the data is sent to the update form (form handler) i 

get an error when i try to update two tables at once from the same form.



cheers karl





> Prefix the form field names with "tablename_" so that when you retrieve 

the

> fields in asp

> you can know to which table they belong to.

> 

> Its just a matter of common sense. You can use any kind of logic  you 

want.

> 

> ----sathish kumar, R

> sathish297@y...

> 

> ----- Original Message -----

> From: "karl hammett" <karl.hammett@b...>

> To: "Access ASP" <access_asp@p...>

> Sent: Wednesday, November 28, 2001 10:30 AM

> Subject: [access_asp] double entry forms

> 

> 

> > hi i'm writing some asp pages for capture inforamtion from an 

access '97

> > database on a server and updated via forms. i can write forms to allo

> > inforamtion to update one table per form. is it possible to have a form

> > that has information from more than 1 table from a database and when 

the

> > submit button is pressed that both talbes are updated.

> >

> > any help would be gratefully received.

> >

> > cheers

> > karl.




> >

> > Read the future with ebooks at B&N

> >

> http://service.bfast.com/bfast/click?

bfmid=2181&sourceid=38934667&categoryid

> =rn_ebooks

> 

> 

> 

> _________________________________________________________

> 

> Do You Yahoo!?

> 

> Get your free @yahoo.com address at http://mail.yahoo.com

> 

> 

>  hi sathish 



i'm not sure i explained the exact problem. 

i can get data from more than i table on a form, but when the submit

button is pressed and the data is sent to the update form (form handler) i 

get an error when i try to update two tables at once from the same form.



cheers karl

Hi



Multiple Table update in Access seems to me a common problem.  I tried to

update information to multiple tables (Employee Information &

EmployeeEmergencyContacts and had the same).  First Update the one table

(your main table in use, i.e. Employee Information) then update the second

table and use the employee id as your reference.



I hope this help.  I'll search through my vb projects to find the exact code

of how I overcame this problem.



Let me know

Helga



-----Original Message-----

From: karl hammett [mailto:karl.hammett@b...]

Sent: Wednesday, November 28, 2001 2:34 PM

To: Access ASP

Subject: [access_asp] Re: double entry forms





 hi sathish



i'm not sure i explained the exact problem.

i can get data from more than i table on a form, but when the submit

button is pressed and the data is sent to the update form (form handler) i

get an error when i try to update two tables at once from the same form.



cheers karl





> Prefix the form field names with "tablename_" so that when you retrieve

the

> fields in asp

> you can know to which table they belong to.

>

> Its just a matter of common sense. You can use any kind of logic  you

want.

>

> ----sathish kumar, R

> sathish297@y...

>

> ----- Original Message -----

> From: "karl hammett" <karl.hammett@b...>

> To: "Access ASP" <access_asp@p...>

> Sent: Wednesday, November 28, 2001 10:30 AM

> Subject: [access_asp] double entry forms

>

>

> > hi i'm writing some asp pages for capture inforamtion from an

access '97

> > database on a server and updated via forms. i can write forms to allo

> > inforamtion to update one table per form. is it possible to have a form

> > that has information from more than 1 table from a database and when

the

> > submit button is pressed that both talbes are updated.

> >

> > any help would be gratefully received.

> >

> > cheers

> > karl.




$subst('Email.Unsub')

> >

> > Read the future with ebooks at B&N

> >

> http://service.bfast.com/bfast/click?

bfmid=2181&sourceid=38934667&categoryid

> =rn_ebooks

>

>

>

> _________________________________________________________

>

> Do You Yahoo!?

>

> Get your free @yahoo.com address at http://mail.yahoo.com

>

>

>  hi sathish



i'm not sure i explained the exact problem.

i can get data from more than i table on a form, but when the submit

button is pressed and the data is sent to the update form (form handler) i

get an error when i try to update two tables at once from the same form.



cheers karl










Read the future with ebooks at B&N

http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid

=rn_ebooks