Is it possible to have a single point feature associated with multiple records in an attribute table?
For example, if I had a shapefile of type POINT containing 100 points indicating fire hydrants but I wanted the attribute table to contain records of all use of the fire hydrants, such that when I clicked on say fire hydrant #80, it selects all the records in the attribute table with use of fire hydrant #80.
I've not tried this yet, but as I understand it, the relationship is 1:1 (1 feature to 1 record). In the given example, if I had 100 features but the attribute table had 500 records, I believe that would be an invalid shapefile correct? The only way to resolve this is to "overlap" features, such that when it appears I am selecting a single feature, there are really, for example, 6 features representing fire hydrant #80 on top of one another. If possible, I would like to not do that kind of workaround.