Jump to content
Sign in to follow this  
haydencohen

Performers and Genres

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.