1 database connection, 2 forms - advice please

[Rick]

I created a <form> and created the fpdb Access database. Published to the
host site and all works well.

I now want to create another <form> page by copying the first - identical
except for the text displayed (which will be in French). When someone fills
in the English form I have a table field "lang" in which the value is "EN".
In my French form this value will be "FR" (<input hidden>).

I want either form to SUBMIT to the same database. Do I simply copy the
english.asp page as french.asp and change the text items? Will it submit the
data to the same fpdb? (or is there some place in the vti_ that links the
database to the form name?

Thanks.

.... Rick

 

[Kathleen Anderson [MVP - FrontPage]]

As long as you don't change the names of the form fields on the page, this
will work. It's even OK if both pages have the same form name, because they
are separate pages.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[SPG]

Rick, you can create as many submission forms as you like. I always make a
copy of the originals and park them just in case I need to redo one. As
long as you haven't modified the basic htm code that submits to the
database, Access could care less
what is put into it, unless you have some validation or field limitations
imposed. Make a copy of the english one and, if I understand you correctly,
change the displayed text that tells the user what is to be entered. All
you have to do is give the user the choice of whether they want to submit in
english or french, then link it to the correct asp page. Having a field in
the db named "lang" makes no difference to Access. Everything will go into
the same db, no problem. When you run the db results form it will show both
english and french records.

Samg

 

[Andrew Murray]

Rick, you can create as many submission forms as you like. I always make
a copy of the originals and park them just in case I need to redo one. As
long as you haven't modified the basic htm code that submits to the
database, Access could care less
what is put into it, unless you have some validation or field limitations
imposed. Make a copy of the english one and, if I understand you
correctly, change the displayed text that tells the user what is to be
entered. All you have to do is give the user the choice of whether they
want to submit in english or french, then link it to the correct asp page.
Having a field in the db named "lang" makes no difference to Access.
Everything will go into the same db, no problem. When you run the db
results form it will show both english and french records.

Samg

If you do have the "lang" field you can query and filter the results with
"results.asp?lang=French" or "results.asp?lang=english"
You'd need that if you want to only list the french records for example
since everything's going into the same database and you probably want a way
to filter the records.


I sort-of have done the thhing you're thinking of - www.murraywebs.com - see
the "select language" links for the introduction on the home page.

All I did was load each translation (translated from Google) into one
database using one form and having a field called Lang.