This can be achieved using different ways.
fill in the other 2 fields.
server side Script you are using such that, it's fills up an array with
the possible values and then match the value entered in first field and
pick the corresponding values from other two arrays. This would require
large page but would eliminate Page Refreshes.
3. Or you can design it like that the page calls another script when
first field is filled (can be coded in onChange event of that field) and
the called script process the value and return back to this page.
If need more explicit help please write directly.
> -----Original Message-----
> From: Sweeney, Darren L [SMTP:5260581@stripped]
> Sent: Saturday, May 22, 1999 12:51 AM
> To: mysql@stripped
> Subject: A Little Off topic
> I am creating a dB application using MySQL.
> When a user fills out a form I want to know if the following is
> The form has 4 fields talking to two tables ...
> When the first field is completed on the form, then the user tabs to
> next, I want a script to look into one of the tables to see if any
> details exist for the record and to fill in the next 2 fields on the
> automatically, then the user can tab to the last field and simply
> the last field ...
> The rest I know to update or insert etc.
> Thanks for all help.