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,