Same answer as on the other board, in case you missed it:
You will have to pull any information in that you wish to
display.
For example, if you wish to auto-fill a state field from a
zip code, then
you would need to pull in your recordset for all zip codes (a
big one) just
to get this one bit of info (at least I don't know of a way
to do it other
than that.)
Then, you'd have to use Javascript or a *client* side
programming language
to autofill the field on completion of the other field. For
example, if
they
fill in zip code, then you'd need to have a function that is
activated
off.focus of the zip code field. This function would have a
switch
statement to compare the value in the field with existing
values from the
recordset, and then populate the correct info in the state
field box.
If you're just pushing data like billing address and shipping
address, you
can do that much easier. Just again setup a client side
scripting language
that off.Focus will shoot field.value => Other
field.value.
HTH,
Jon
"Ken Ha Quad" <webforumsuser@macromedia.com> wrote in
message
news:eab8fj$obk$1@forums.macromedia.com...
> Hey all:
>
> Posted this to general discussion but maybe this is the
place for it.
> Suppose
> I have a PHP/MySQL setup to where users registering on a
website must
> enter
> their address. Now I could simply require everyone to
enter name,
> address,
> city, state, and ZIP code, but that would be a lot of
trouble. Instead,
> I'd
> like to have them enter name, address, and ZIP code,
then have the
> application
> look up the ZIP code in another database and enter the
city and state
> accordingly. I'm reading "Dreamweaver 8, the Missing
Manual". The author
> refers to this function (form variables) but states that
the function
> would
> generally be used on two separate pages, such as a
search and result
> setup.
> Does anyone know how the "results" can be made to appear
dynamically in
> another
> field of the form?
>
> Thanks,
> Ken Ha Quad
>
1
Reply
AdChoices