Bill Blancett
|
| Posted: 08/29/2001, 4:30 PM |
|
I am working on web pages that are connected to 12 mysql tables. My first
page retrieves personal information from the user and stores it all in one
table called the applicant table. After the person fills out the form and
presses submit,it inserts record in the applicant table, the applicant_id is
passed to the next page. I want to use the applicant_id to populate other
related tables using different forms. The user fills out another form linked
to another table but linked by the applicant_id. Basically pass the primary
key to the next page or form and use that key to insert info into another
related table. Is this possible or should I just stuff everything into one
big table ?
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 08/30/2001, 7:15 AM |
|
It's ok, just pass applicant id to the next form , mark in Input tab
as "Transfer" parameter , so that the following forms could retrieve it
--
Alex
Bill Blancett <bblancett@hbu.edu> wrote in message
news:9mjtu3$s59$1@news.codecharge.com...
> I am working on web pages that are connected to 12 mysql tables. My first
> page retrieves personal information from the user and stores it all in one
> table called the applicant table. After the person fills out the form and
> presses submit,it inserts record in the applicant table, the applicant_id
is
> passed to the next page. I want to use the applicant_id to populate other
> related tables using different forms. The user fills out another form
linked
> to another table but linked by the applicant_id. Basically pass the
primary
> key to the next page or form and use that key to insert info into another
> related table. Is this possible or should I just stuff everything into one
> big table ?
>
>
|
|
|
|
|
