What functions do I need to use to do the following:

[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