Hi all,
I have recently come across the HIERARCHYID data type in SQL server and it looks like it's gonna work great for my hierarchies.
I can produce something like this:
However, I would like to know how I should work with this in MS Access. For example, if I want to add a new category, I want to select the parent from a combo box (NULL = this is a new root, selected category = this is a child of that category).
Can you please advise how I should do this, so the correct hex node is saved in the SQL Server?
Another question would be about aggregate queries. Let's say that I want to show total sales of a category, including its child categories. How should I do that?
Thanks a lot for any advice and wish you a nice weekend.
Best regards,
Tomas