Subgroups and levels... complex question...

[thorgil]

Background info.

I have four levels of grouping.

level 1 and level 4 are always present.

level 2 and 3 are sometimes present.

data looks something like this (all in one table-can't change it..."supernormalized sort of")

TABLE ( UBBcode code doesn't work for me excuse the ".'s")

id.....level...parent_id....data

1......1.........0..................Q group

2......1.........0..................A and B group

3......2.........2..................A subgroup

4......3.........3..................asdf subsubgroup

5......2.........2..................B subgroup

93....4.........1..................qwerty

94....4.........4..................asdf1

95....4.........4..................asdf2

The given value is the "parent" of a level four record

and i want rows looking like this (depending on level 4 id's):

Level_1..............Level_2.........Level_3..........Level_4

Q group..............None.............None..............qwerty

A & B group.......A group.........asdf group.....asdf1

A & B group.......A group.........asdf group.....asdf2

I can do with just the id's also... But is this possible in fmp?

I was thinking about using scripts (i guess i have to...) but how do i execute a script when a calculated value (level 4 id's) is changed?

/Tobias, fm newbie

Ps:

Does anyone understand what i'm asking?

S

[kennedy]

Sure. Define three calculation fields:

c_level3 = If(PARENT::level = 3, PARENT::data, "None")

c_level2 = If(GPARENT::level = 2, GPARENT::data, "None")

c_level1 = If(PARENT::level = 1, PARENT::data, If(GGPARENT::level = 1, GGPARENT::data, "None"))

Then create a layout with four columns

c_level1 c_level2 c_level3 data

and do a Find on level=4.

HTH

[Ugo DI LUCA]

Don't know if it would help, but I've been playing with category-like display files for some time.

Have a look at a thread called 882Summaries as there's a little sample attached at the end.

[thorgil]

Con't find the thread Ugo.

Can you post a link?

/T

[Ugo DI LUCA]

882 summaries

Note that I agree with Brian about the calc. It's just that this may also help. It's not a 4 column report, it's a portal view and the way it is set for hierarchy display.

[thorgil]

ok, thanx...

Brians style seems to work for me....