There has been some great discussion on updating tables here. I hope that the contributions have been beneficial to people. But, as a general purpose GIS tool, I think MF would really benefit from some point-and-click table joins (wow, this must be the end times - I'm advocating for point-and-click wizards over SQL!). Two things that come to mind: 1. Join tables based on an attribute, then right click columns to "flatten" them as we did with 8. That is super handy, and can be done with one hand, while the other hand is having a drink. The Table -> Relations capability was really useful in this way. 2. Take a tip from ArcGIS with their Select by Location, by joining two tables based on their geometry columns. Then, you can do another flatten. In this case, when performing the Table -> Relation, you can select the geometry column from one table, and a geometry column with another table. Of course, there is some added complexity as you need to determine what the relationship is (i.e. contains, touches, intersects, etc.). I think this is an excellent way to perform these kinds of tasks for users who don't want to write SQL, and as I'm teaching people how to use MF, it is really obvious that if something simple like the above examples are desired, the Table -> Relations route is much faster than trying to write an update statement.
|