Dear Listers I am trying to thematically map water usage by land parcel using three tables. The three tables are...
Parcel.tab is the land parcel polygons. Owner.tab are points with contact details. A parcel may have multiple owners, and multiple parcels may belong to one owner.IE Many to Many relationship. WaterMeter.tab is an unmapped Excel spreadsheet listing each Owner's KeyID and quarterly water consumption data. An owner may have more than one meter and a meter may supply more than one parcel. If I run this SQL statement... Select * >From OwnerDetails,WaterMeter Where Owner.KeyID = WaterMeter.KeyID into Table Named OwnerMeterLink I get a table with all fields from the two tables. Great! The problem is the next step. Select Sum(WaterMeter.Q1Units),Owner.KeyID >From Parcel, OwnerMeterLink where Parcel.obj contains OwnerMeterLink.obj MI only allows dynamic joins between base tables. How can I set up my workspace to dynamically link the Watermeter table to the parcel table? The end result I am trying to achieve is to show the sum of the water used by all meters associated with each parcel. James Torrie GIS Officer Rangitikei District Council New Zealand PS I dont want to have to geocode the excel spreadsheet every 3 months (if a meter supplies two parcels, only one parcel will recieve a point label), and I musn't add extra fields to the tables. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3961
