Multiple choices list in a table

  • Thread starter Thread starter Guy Verville
  • Start date Start date
G

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
 
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.
 
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
 
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.
 
Back
Top