Hi, not sure if this is possible or not.
I have a bunch of 'nested' tables in Excel (Parent/Level) which I need to be able to view as Collapse/Expand and then to be able to drag-drop any part of a hierarchy anywhere else and have it update Parent/Level. Additionally I need to be able to have the option to say 'Copy' which would make an 'instance' of the records so that even though they are part of two hierarchies a change to any is a change to all.
I found a product that seemed to do that visually;
[login to view URL]
but am told it is 'hard coded'.
Basically I need to be able to review very large nested tables more efficiently than in Excel (detailed to simple) and move/modify structure quickly w/o copy, scroll, paste, update relationships, etc.
I have additional needs that a tool named Navicat would supply (Query/Funciton building connected to sqlserver) but not sure if that can do the views I need.
I would prefer this in a SqlServer interface but if anyone can do it in Excel as first step that is acceptable.