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.
