How would I make one table meet four categories in my relationship. I am doing a choral music database for our school. So I have the following:

Mixed, Men, Women, Small Ensemble.  Each of these libraries have the same information such as;

Title, composer, Arranger, Lyricist, Voicing, etc.....

So when I person clicks on Mixed they get all the information categories that they would get if they picked Men, just different information in them. So would I just make four tables of the categories and have each one have a Primary key, then make on table with all the information fields and have a PK, and then each of the categries would have the FK? Thank you. 

 

I believe you should have one table, with a field for the type of choir. Then do a find for the type they clicked on. Or you could use a filtered portal to show the selected type.

Comment is right.

Do we need to be thinking about further potential categories - SATB / SAB / SSATTB etc?

Also - some pieces could be in multiple categories - an SATB piece for full choir / chamber choir etc. I'd use a checkbox to tick all categories a piece is in.

Thank you to both of you. Sorry it took so long for me to reply. I will work on your suggestions. Thank you.