Quick rant on joins in ArcMap
Working with some tabular data and some point feature classes in ArcMap. I want to do a one point feature to many row join but I could also settle for a definition query where I would end up with 1 feature to 1 row
Step 1 – export the Query to a table in my personal geodb and then try to join on the appropriate fields – join works (after I follow all the rules) but it doesn’t respect the Definition query I put on the table…grrrr
Step 2 – go to the support find and that this is a known issue
Step 3 – go talk to some of the GIS analysts and they reccomend a relate rather than a join. Trouble is you can’t symbolize by a relate, it just looks like it is intended for editing.
Right now I am looking at generating 1 DBF or table per definition query I would have used above and then joining. This stinks… Does anyone have better suggestions to this issue.