I am a VB programmer and have tried numerous ways to accomplish the following, but can't figure it out. I have a customer table which includes a customer type (For example, GAS STATION, RESTAURANT, etc.). I want to display pushpins for each customer in the table, but want a different symbol to display based on the customer type. I have another table with the various customer types and symbol number I want displayed for the type. I can join this table to the customer table.

I've played with the LINKDATA, but that doesn't allow me to select customers by TYPE, nor will it group the table information by type. I could create a VIEW, but I'd need a different VIEW for each customer type and want the user to be able to setup their own types and pick a symbol they want to display. I've tried FETCHING through a recordset using a GETLOCATION, ADDPUSHPIN technique, but the performance really stinks to the point that is unusable. The performance of the LINKDATA seems alot more acceptable.

Any ideas on how I can accomplish what I am trying to do ?

Thank you in advance,
Mike Sachais
mikesachais@cswebmail.com

When you are importing your data are you creating one big dataset? If so, break it down by importing customer types into its own dataset. Changing the Pushpin for a dataset is easy and quick.

Mike,

I am in the initial stages of exploring the functionalityof various mapping apps. It seems from your post that what you are trying to achieve matches my requirement spec exactly. Please keep this thread updated so that I can follow. I may be interested in combining resources. (my budget your dev).

regardless, good luck.
Paul.