MapInfo Users I have a dataset containing 55000+ records. One of the columns in my TAB file is "classification code". By writing a SQL query I am able to filter the TAB file to provide me with just a 'selected set' of records based on the classification code. However, as I need to do this possibly more than 50 times (create 50 layers!!) I was wondering if there was an "automation process" that I could use such that whenever I received an update to the dataset from our suppliers I could run a query that would produce 50 different layers based on my classification code. A colleague suggested writing a macro but forgive my ignorance as I don't know where to start. I also thought that I may be able to write a SQL select statement that would be saved as a template, though I am unsure how this would split the tables! Can anyone help?
Thanks. Vinesh _______________________________________________________________________ The contents of this message do not necessarily represent the opinions, views, policy or procedures of Leicestershire County Council.
