Given a table that looks like the following
L1 L2 L3 L4 L5...
R1
I want to display the data as
L1
L2
L2
L3
L4
L2
L2
L1
L2
L3
Can anyone think of an any way to do this and a way that removes all the duplicates?
I can get it like the following. It shows the entire heirarchy for each row, which is wrong.
L1
L2
L3
L1
L2
L3
I figured this out.
Create several nested lists. Each list having a data item of the next list down to link to. Create a master/detail for each list starting from the top
then create a huge filter because the users want optional prompts for 10 levels thats says something like
(?Param1? IS MISSING? OR <Field1>=?Param1?) AND (?Param2? Is MISSING OR <Field2>=?Param2?) etc.. etc.. etc..