MTA Row Source Property

[C. Sharp]

Is there a way to use Row Source Property to pull multiple Vendor types into
another table? Ex: I want to pull the name, address, phone of a ground
transportation company -AND- a hotel into an Events table. Please help!

Thanks in advance,
c. Sharp

 

[Pat Hartman \(MVP\)]

Sounds like a design issue if you have separate tables for different types
of vendors. If they were in the same table, you could use a query with
criteria similar to the following:
Where VendorType = 1 or VendorType = 2;