Hierarichal

[Ravenix]

Yes another one that searches for hierarichal things. :

I've searched the whole day on google, but i couldn't find anything that will help me. i will explain what i want.

I have a table with content and another one wich says it's an parent or an child

-----------

[ content ]

-----------

[ -id ]

[ -text ]

-----------

-----------

[ link ]

-----------

[ -parent ]

[ -child ]

-----------

so...

[ content ]-----<[ content ]

How can i make an Hierarichal portal for this?

thank you verry verry much!

grtz Ravenix

Edited June 12, 2009 by Guest

[bcooney]

I have no idea what you're asking, a bit too abstract. Can you use real data in your explanation.

[comment]

What is the purpose of the linking table? Do you have content records that belong to more than one parent?

[Ravenix]

ok, some more information :

for example:

base

id        name      root-group

1       1st-one         1

groupmodel:

id       name

1     group one

2     group two

3     group three

4     group four

5     group five

6     group six

parentgroup_subgroup

parent_id       child_id

   1                2

   1                3

   2                4

   3                5

   4                6

I want to view this in an portal like this:

- group one                  [+] [-] [e]

    - group two              [+] [-] [e]

        - group four         [+] [-] [e]

            - group six      [+] [-] [e]

    - group three            [+] [-] [e]

        - group five         [+] [-] [e]

but also to expand and collapse it. and also to add/edit/delete items.

thanks in advance!

Greetings Ravenix

Edited June 15, 2009 by Guest

[polarpro]

Hey Ravenix,

I, too, am busy trying to understand hierarchies in Filemaker (and soon I might ask here a few questions myself )

It looks like it is a rather complex topic.

Here is what I’ve found so far:

Mikhail Edoshin wrote a white paper on how to implement hierarchical structures in Filemaker:

http://edoshin.skeletonkey.com/2008/07/hierarchies-in.html

(Look for the link at the very top of the webpage.)

In this paper he also describes a very interesting and simple basic hierarchical structure with a custom order of child records at the bottom of page 3.

Edoshin describes hierarchical tree views in list view; when it comes to tree views in portals these three solutions here might be of interest for you:

Excelisys

http://www.excelisys.com/web/downloads/index.php

Hierarchical Portals (white paper and demo) and Hierarchical Portals Advanced (demo)

Seedcode

http://www.seedcode.com/cp-app/ste_cat/schierarchy

Seedcode sells a very professional looking solution.

Filemaker Magazine

http://www.filemakermagazine.com/videos/unlimited-infinite-hierarchies.html

This solution requires Filemaker 10.

The first three mentioned sources also deal with expanding and collapsing, adding and deleting items.

(Um... as for searching Google all day long: Have you tried entering filemaker hierarchies? : )

[comment]

I don't think that answers my question. In any case, you can download demos of hierarchical portals here:

http://www.excelisys.com/web/downloads/index.php

http://www.seedcode.com/downloads

and take them apart to see how they work. Note that this is a particularly difficult undertaking, hardly suitable for a beginner.

[Ravenix]

...(Um... as for searching Google all day long: Have you tried entering filemaker hierarchies? : )

Yes for 2 days almost now.. And so i've already saw that 3 demo's. But they're build on a different view of the problem. They look to the problem as designers of the layout. I look to the problem as a database designer

grtz Ravenix