how do i achieve nested grouping?
my database is one of perfumes. there are 800+ and counting, made by 200+ brands. i have a calculated field that displays the first letter of each brand name. in my table view, i want to group perfume records by brand name and then group brands by initial letter. however, each time i click to group on the second of these fields, the initial grouping is removed.
(please refrain from suggesting that i just search for the brands or perfumes instead of browsing.)
5 replies
-
In table view you can create a extra column (chose formula in the show/hide menu if you click on a column header)with the concatenation of the two columns you wisch to order.
'Brand initial' +" "+'Brand Name'Steven
-
Thanks Steven, but I think you may have misunderstood my question. The issue is not sorting by these columns or viewing them one after the other. I am looking for grouping of records for one brand INSIDE of a group of brands for one initial letter. That is, ~26 groups at the top level, then a handful of subgroups within each letter-based group. What you are suggesting would not create two levels of grouping. Instead it results in simply grouping on each individual brand (just with the initial letter specified in front of it), which is not the point.
-
Is your data model a single table? If it is, I would suggest you create a separate table for brands and one for perfumes and create a reference between them. But, if you are hoping to collapse/expand perfumes for each brand in table view, you can't using the Ninox interface. You can select a brand and get a concatenated list of perfumes in table view and in form view you will see a subtable of perfumes.
-
No, it's not a single table. The main detail table is Fragrance, and there are two lookup tables, House (i.e. "brand") and Perfumer, each with a 1:N relationship to Fragrance. House consists of House.Name and House.#, which is a calculated field displaying the initial letter of the House name.
I don't know why you say one can't expand/collapse the perfumes for each brand in table view. I already am doing that (see screenshot here: https://photos.google.com/search/_tra_/photo/AF1QipN0lBx0uSd0Kf8qUT_IX-tknNdIY6Ty66T0D-64). The only question is how to, after collapsing perfumes into groups by their House, further group those Houses by their initial letter. When I go to add grouping on the House.# column, it eliminates my House.Name grouping instead of prompting me for the order of grouping.
-
I think you answered your own question. You can do one or the other, but not both.
Content aside
- 3 yrs agoLast active
- 5Replies
- 799Views