All:I have a module, that is built upon many parts, with some parts being assemble with a collection of other parts. Each assembly is a level so for example:
Level 1 - Master Module
Level 2 - Mounting Bracket
Level 3 - Bracket
Level 3 - Screws
So in essence it takes all the Level 3 components to make the Level 2 part, and all roll up to the Level 1 master module.
When I pull down the information from production, it is in the view as this by numbers, no child numbers, just 1,2,3,3, then if there is another Level 2, it would be 1,2,3,3,2,4,4, etc.
I am trying to build a column to categorize all this so it would be like:
1-Module
-> 2 - Mounting Bracket
-> -> 3 - Metal Bracket (1)
-> -> 3 - 1/4" Screws (4)
-> 2 - Hose Assemby
-> -> 3 - 2' 1/2" Flex Hosing
-> -> 3 - 1/2" Clamps (4)
Something like that.
I tried this for a formula:
Level := @Text(STBSTUFE);
@If(
Level = ""; "";
Level = "1"; "1";
Level = "2"; "1\\2";
Level = "3"; "1\\2\\3";
Level = "4"; "1\\2\\3\\4";
"1\\2\\3\\4\\5"
)
But in this manner, it is not quite right, in that it does the Module for Level 1, but then for the Level 2, it has a Level 1 twistee and Level 2 twisee, etc.
Any thoughts?
David