Hi Dan
You could avoid having duplicate datasets at all by using a hotlinking
program,
such as MapLinker. Basically it was designed to do what you want to do, and
it means that you can use your ID in your mappable field to link to a
database record with the same ID. Therefore if you click on the house in MI,
the corresponding access table will open and give you all the information
you require, thus removing the need for duplicate information and allowing
it to be updated whenever you need to. Unlike MI hotlinks, it also lets you
link back from access to the corresponding map object in MI, and you can
link numerous file types to a single map object (eg. a photo, an access
form, a word document etc)
If you are interested, contact your local reseller (details at
www.geobasemap.coom) or have a look at our website
(www.pelicangeographics.co.uk).
regards
Caroline
*************************
Dr C Hilton
Pelican GeoGraphics
London SE21 8ED
[EMAIL PROTECTED]
www.pelicangeographics.co.uk
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; Franco P. Peta <[EMAIL PROTECTED]>
Sent: Tuesday, July 24, 2001 9:42 PM
Subject: Re: MI-L linking tables
That's what I thought but was hoping I was wrong. I have many relational
databases in MS Access that have several tables linked and was hoping I
didn't
have to create and manage duplicate database and tables in order to show
this
information in MapInfo also.
Dan
"Franco P. Peta" <[EMAIL PROTECTED]> on 07/24/2001 04:34:20 PM
Please respond to "Franco P. Peta" <[EMAIL PROTECTED]>
To: Dan Page/HullOttawa/PCH/CA@PCH
cc:
Subject: Re: MI-L linking tables
As you said, it it not possible. GIS are stick to flat tables, one "real"
one row or record.
The rest is Sql and queries.
Or I am wrong?
Mi does not accept - if possible to say - dinamic one to many relations.
Juanse
Temuko
Chile
www.matilde.cl
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 24, 2001 4:24 PM
Subject: MI-L linking tables
> I should explain my situation a little better. Lets say table1 represent
> residential homes, one record for each house. Each house has a unique ID
number.
> In table2 (not mappable) is a list of occupants or residence names and
other
> information about that occupant. Each record represents one occupant. It
has no
> unique field but does contain the house ID number of the home in which the
> occupant lives. Therefore if a house has 3 occupants, 3 records will have
the
> same ID. What I would like to do is keep these tables seperate but be
able to
> click on a house and have the information in table1 show up in the INFO
window
> and also be able to see the information associated with each occupant in
that
> house which comes from table2. Maybe this isn't possible without joining
the two
> tables and creating one big flat table?
>
> Dan
>
>
> I have two tables, one with objects , the other with information about the
> objects (not mappable)
> They both have a common ID field. Is it possible to keep these tables
separate
> in
> MapInfo and be able to link them together so that when you click on an
object
> the information in the second table will also be shown in the mapinfo
window?
>
> I'm running MI 6.0 and do not have MapBasic.
>
> TIA
>
> Dan
>
>
>
>
> _______________________________________________________________________
> 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.
_______________________________________________________________________
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.