Multiple choices list in a table

[Guy Verville]

Hi,

I'm building a database for a choir association. The main table called
Choirs includes a topic MusicPerformed. This field should be multichoiced,
e.g. Baroque, Classical, Popular (a choir can sing many type of music). I'm
perplexed about this. Since there are 20 choices, what is the best way to
implement this? 20 fields?

Guy

 

[Duane Hookom]

You should create a related table that has one record per Choir per
MusicType. This would be similar to the Northwind order entry tables where a
single order can have multiple order details (products). If a choir
performed 10 types of music, there would be 10 records in the ChoirMusicType
table.

 

[Guy Verville]

Thanks for your reply. I tried to open the Northwind database but it
requires a SQLserver. I tried to open that on my CD but it requires then a
complexe SA password!

I must say that I did at first create a MusicType table and associated a
correspondent MusicTypeID in my Choirs table. However, it's how to show this
in a form that is problematic for me.

Guy

 

[Duane Hookom]

There are now two Northwinds. One is for standard Access tables and the
other is "CS" for client/server. You would add records to the related table
with a subform that has its link master child properties set to the ChoirID.
This is similar to the order details subform.