I'm working on a google mashup map. Currently I have it working where I select a state dropdown and the results show all of my inspectors for that state. Great.
I'd like to take the mashup a step further. I'd like to search my customers, select the customer I need and I want the mashup to have the pin set for the customer AND bring back google pins for all the inspectors in the area of my customer.
It would effectively read two tables, the customer table and then the inspector table.
Is it possible to create this?