Has anyone had success relating tables to related tables in ArcMap and ArcPad. For example, I am collecting geological data so I have a point class GeologicalFeature. From that point, currently I have 7 related tables (Contact, Fault, GenFormation, Joint, Lithology, MiscFeature, Structure). The problem is that because they all relate to the point, they aren't related to each other.
To illustrate: A Contact may contain 2 Formations. A Formation may contain 1 or multiple Lithologies. But you don't always have a contact, maybe just a Formation with 1 or multiple Lithologies.
So, the necessary structure is fairly complicated and involves tables related to tables related to tables related to a point and some tables related to both another table as well as the point.
Every time that I throw more complexity into this project, I just assume that ArcPad/ArcGIS will not support it, so please give me a reassuring word.
________Edit
Ok, so I asked this question before I tried it anticipating problems. It seems that you can't relate a table to a table, then relate it to anything else using a composite relationship. It looks like simple relationships will work, but not composite. The problem with simple, is that it leaves orphaned records as well as destroying your .AXF file if you ever delete anything. DO NOT USE SIMPLE RELATIONSHIPS if you are going to check out that data in ArcPad. It will drive you insane!
