Dynamically populating form fields

[galeemma]

I have a form that will be available for users to complete to add information
to my database.

When they log in they provide their department code which is saved as a
session variable. What I want to do is when they click the link to "ADD DATA"
- I would like the cells of the table that contain the information relevant to
that department for instance, manager, location etc to fill automatically. I
can get the department number to display on the form as this is the session
variable but it doesnt update in the database and leaves a blank field. Some
of the remainnig fields will be input fields that they will provide the
information for which I have updating the database nicely. Other bits of
information wil be relevant to the session variable but pulled from the
recordset.

Is this possible? Help will be gratefullly appreciated.

Kind regards
Emma Gale

[Nancy Gill]

Sure .. filter the recordset by the session variable and bind the columns
that are to be autofilled to the text fields that should already be filled
in.


--
Nancy Gill
Team Macromedia Volunteer for Dreamweaver MX/UltraDev
[url]http://www.macromedia.com/go/team/[/url]
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"galeemma" <webforumsuser@macromedia.com> wrote in message
news:d48fie$ej7$1@forums.macromedia.com...

> I have a form that will be available for users to complete to add

information

> to my database.
>
> When they log in they provide their department code which is saved as a
> session variable. What I want to do is when they click the link to "ADD

DATA"

> - I would like the cells of the table that contain the information

relevant to

> that department for instance, manager, location etc to fill automatically.

I

> can get the department number to display on the form as this is the

session

> variable but it doesnt update in the database and leaves a blank field.

Some

> of the remainnig fields will be input fields that they will provide the
> information for which I have updating the database nicely. Other bits of
> information wil be relevant to the session variable but pulled from the
> recordset.
>
> Is this possible? Help will be gratefullly appreciated.
>
> Kind regards
> Emma Gale
>
>

[galeemma]

Thank you Nancy,

I take it that means that I have to include text fields. I did think about
that but I was hoping that there would be a way that would allow me to do this
without allowing ther user to edit them.

best wishes emma

[CarlGrint]

You could add Hidden fields, so the data is not show, but is still available to
you to add into the database via your form.

Originally posted by: galeemma
Thank you Nancy,

I take it that means that I have to include text fields. I did think about
that but I was hoping that there would be a way that would allow me to do this
without allowing ther user to edit them.

best wishes emma

[Nancy Gill]

Yes, definitely .. Just set a name for your hidden field and bind the active
column to the hidden field rather than a text field. As long as the hidden
field is within the form parameter, you will still see the field in the
Insert Record behavior.


--
Nancy Gill
Team Macromedia Volunteer for Dreamweaver MX/UltraDev
[url]http://www.macromedia.com/go/team/[/url]
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"CarlGrint" <webforumsuser@macromedia.com> wrote in message
news:d48j52$k8e$1@forums.macromedia.com...

> You could add Hidden fields, so the data is not show, but is still

available to

> you to add into the database via your form.
>
> Originally posted by: galeemma
> Thank you Nancy,
>
> I take it that means that I have to include text fields. I did think

about

> that but I was hoping that there would be a way that would allow me to do

this

> without allowing ther user to edit them.
>
> best wishes emma
>
>
>