This topic touches on a question I have. Not being a database expert, maybe
it's a simple question and I don't know it , but how do you use MapInfo or a GIS
with a relational database in which the information is located in many tables
that are linked? Can relational databases that are created in Access for example
be used in MapInfo so that when you click on an object in MapInfo all the
information from various linked tables for that record will be shown either in
MapInfo window or in an Access form? How does one go about using relational
databases in MapInfo without having to extract and import separate flat tables
and produce duplicate databases? I have only had to work with flat tables in
MapInfo but I'm sure one day the need to link a relational database to MapInfo
or a GIS will come up. Anyone have experience doing this? Is it feasible?
TIA
Dan
"Tim Warman" <[EMAIL PROTECTED]> on 05/01/2001 04:44:43 PM
Please respond to "Tim Warman" <[EMAIL PROTECTED]>
To: "Mapinfo-L" <[EMAIL PROTECTED]>
cc: (bcc: Dan Page/HullOttawa/PCH/CA)
Subject: SUM: MI-L mismatch between map & browser windows
after query
Okay, the answer straight from MapInfo Tech Support is "It's supposed to
work that way".
How disappointing.
MI's suggestion was to save a copy of the query result, which does seem to
correct the problem. They claim that MI doesn't really support one-to-many
joins, and that this lack of support shows up when trying to use the info
tool in a map window with a temporary query table spawned from a one-to-many
join.
Cheers,
_____________________________
Tim Warman
Groundwater Geologist/GIS Guy
Richard C. Slade & Associates LLC
North Hollywood, CA, USA
+1 (818) 506 0418
-----Original Message-----
From: Roger Therrien [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 12:42 PM
To: Tim Warman
Subject: Re: MI-L mismatch between map & browser windows after query
I get exactly the same problem with my SQL query generate table using MI
v6.0.
I hope somebody knows the answer to this one.
Roger
Tim Warman wrote:
> Hey Listers,
>
> I have one table containing water well locations, and a second containing
> water level elevations in these wells, measured at various times over the
> past 50 years.
>
> I've run a query to join the two tables and find any water level data for
> the spring of 2000 - the output goes into a new table called Spring_2000.
In
> the browser window for Spring_2000 I find (for example) three records for
> Well 19, consisting of water levels for each of the three spring months.
> But, when I map Spring_2000 and click on a well with the info tool, I only
> see one record repeated three times.
>
> TIA
>
> _____________________________
> Tim Warman
> Groundwater Geologist/GIS Guy
> Richard C. Slade & Associates LLC
> North Hollywood, CA, USA
> +1 (818) 506 0418
>
> _______________________________________________________________________
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, send e-mail to [EMAIL PROTECTED] and
> put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
