Look up and fill in field values

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
crimmelcp
Forum Newbie
Posts: 16
Joined: Mon Jan 28, 2008 8:48 pm

Look up and fill in field values

Post 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
User avatar
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

Post 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.
(#10850)
Post Reply