Populate product field based on vendor

Populate product field based on vendor

Hi,

In our lead entry form we have a lookup field for a vendor.  We also want to populate another field (lookup or picklist) based on the value of this vendor, drawing down from the products module where the vendor name is matching.

Is this possible?

Thanks,
David