MTA Row Source Property

[C. Sharp]

I have 2 tables: Events and Vendors. I want to be able to enter data in the
Events table fields: Hotel Name, Hotel Address, Hotel Country from a drop
down list but I want that data to come from my Vendor Table fields: VenNAME,
VenADDRESS and VENcountry. Is there a way I can select from the drop
downlist on the Events Table the Hotel Name and it propagate the rest of
these fields? Please help!

Thanks in advance!
C. Sharp