When needing a quick answer to what tables are affected, I sometimes run the profiler.  I then make the change on the UI and then search the ObjectName field for tI_, tU_, tD_.  Those are the insert, update, and delete triggers.  While the tables affected can change depending upon what is happening, the basic tables will likely always show up.

When needing a quick answer to what tables are affected, I sometimes run the profiler.  I then make the change on the UI and then search the ObjectName field for tI_, tU_, tD_.  Those are the insert, update, and delete triggers.  While the tables affected can change depending upon what is happening, the basic tables will likely always show up.

I usually try that too - but unfortunately I can't get the Navigation Task to save so I didn't think I'd get much information. I'll try it on another view thats working though, thanks!