Sounds like problem described involves having many-many relationship
between tables rather than one-many.
If I remember correctly, you can get mapinfo to create these "lookup"
tables automatically. See Bill T's "Streets.DOC" thingie on the
website. I've used the technique to create a few of these joined views.
Apologies if the previous line duplicates a previous post. I'm feeling
an undefined sense of deja vu.
Dan Ryan
Mills College
Oakland, CA
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]