Page 1 of 1

Look up and fill in field values

Posted: Mon Feb 25, 2008 6:54 pm
by crimmelcp
To All:
What functions do I need to use to do the following:
I have a vendor table with the fields
Vendor ID
name
address
city
state
zip
I want a lookup field on a form for Vendor ID
When selected it will fill in
name
address
city
state
zip

Thanks
Charlie Crimmel

Re: Look up and fill in field values

Posted: Mon Feb 25, 2008 7:07 pm
by Christopher
I am assuming you want to use PHP. What database are you using?

For the SQL, you will use SELECT to fetch the data and use UPDATE to save the changes.