Skip to main content
Participant
July 20, 2006
Question

Dependant text field

  • July 20, 2006
  • 1 reply
  • 271 views
I have a question about text fields, what I want to do I believe should be simple, but can't figure it out.

I have a form with various fields 4 of which are linked to a recordset, one of the is a ClientID, the other 3 are first, last, and middle name fields. I want the user to type the ClientID into the client ID field, then refresh the recordset and display the coresponding first, last, and middle name for that client. Any suggestions on how to accomplish this would be greaty appreciated.
This topic has been closed for replies.

1 reply

Inspiring
July 20, 2006
Have a form before your edit page.

This form just says "client ID an dpassword", you hit enter, it verifies you
(much like a login, in fact you could easily use a login behavior) and then
it takes you to the edit screen, which uses a SessionID (your userID) to
pull in your data. (filter rs by the session variable that contains the iD)

Otherwise, anybody who types in any id can edit any company. You might as
well just make a drop-down list of all companies, and have them select their
userID from it to edit.

HTH,

Jon

"USPO" <webforumsuser@macromedia.com> wrote in message
news:e9o9l5$hji$1@forums.macromedia.com...
>I have a question about text fields, what I want to do I believe should be
> simple, but can't figure it out.
>
> I have a form with various fields 4 of which are linked to a recordset,
> one of
> the is a ClientID, the other 3 are first, last, and middle name fields. I
> want
> the user to type the ClientID into the client ID field, then refresh the
> recordset and display the coresponding first, last, and middle name for
> that
> client. Any suggestions on how to accomplish this would be greaty
> appreciated.
>