I have a base for my Dispatching business and i deal with brokerages that have different reps. I got a Brokerage Table and Contacts table for each individual rep and i link them to their particular Brokerage. I have another table where i keep Trips table but i want to know is their a way to bring in a field where i can search inside the linked records of the individual Brokerage?
