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
Look up and fill in field values
Moderator: General Moderators
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: Look up and fill in field values
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.
For the SQL, you will use SELECT to fetch the data and use UPDATE to save the changes.
(#10850)