I created a Product database that has two basic forms (Products  & Vendors). The forms are linked together by a "lookup" field called "Vendor ID" in the Products form.  I have two other fields in the Vendors form called "Drop Ship Fee" and "Percent Discount".  What I need is to automatically update the same two fields in the Product form whenever I update them in the Vendor form.  For instance, if the "Drop Ship Fee" field changes from $3 to $5, for one vendor, I need all the records in the Product form, for that vendor, to automatically update to $5.  Is there any way to do this?    

Regards,

Tom