Performers and Genres

[haydencohen]

Hi Everyone,

I'm in the middle of creating a large database but am relatively new to filemaker. I have performers and am wanting to assign genres to each performer.

So far I have three tables:

Performers

Genres

PerformerGenres

The Performers table has PerformerID, PerformerName, Performer address etc.

The Genres table has GenreID, GenreName and ParentID (for example Jazz would come under Music)

PerformerGenres has PerformerGenresID, PerformerID and GenreID

What I'm wanting to do is have one layout whereby I can add a genre on the fly but with the ability to have layers. e.g:

Music

- Classical

- Jazz

- Rock

Comedy

etc.....

I also want the option of adding more than one genre/subgenre.

Please could you tell me how this can be done?

Thanks in anticipation

Hayden

[Søren Dyhr]

....read this thread!

http://www.fmforums.com/forum/showtopic.php?tid/200332/

--sd

[haydencohen]

thanks for the link, but it doesn't seem to answer my query as there wasn't a resolution. Surely it can't be as difficult as it sounds.

[Søren Dyhr]

Then dissect these templates:

http://www.excelisys.com/web/downloads/files/Hierarchy.zip

http://www.excelisys.com/web/downloads/files/HierarchyAdv.zip

...and eclectically pick the bits and pieces you need!

--sd