I have access 2003 and can not open or use an accdb file.
I suggest you should normalize your tables. I don't know your environment but it seems you have:
Dancers who "perform/specialize" in DanceTypes and who live in Countries that in some cases are broken down into States/Cities.
There appears to be some confusion with your presentation/recording of Country/City/State. You have Australia, London, Wales and Kansas at the "same level" which will be a nightmare in forms and reports. You should define/describe Country so the rest of us understand exactly what you mean.
You should have a table for DanceTypes such as
Code:
id dancetype
1 Modern
2 Ballet
3 Tap
4 another type
5 yet another
I would suggest a Table for Countries (recognized ISO Countries or something) so that spelling errors
(such as UnitedJingdon/London can be avoided).
Clearly identify what a State/Province/Territory is and adjust you data values accordingly.
Can a Dancer have more than 1 DanceType?
I would suggest you should also clearly define/describe what exactly a Category represents. It isn't clear to me.
Similarly, I'm not following where Skill fits in your scenario.
You may need a separate Skill table with values (meaningful to you and those you communicate with) like
Code:
Id SkillLevel
1 Beginner
2 Level1
3 Proficient
4 Professional
Also you should investigate Junction Tables. You may want information such as
Dancer ( Fritz) has skill level (Proficient) in DanceType (Modern) and Lives in (Kansas, United States)
Dancer ( Fritz) has skill level (Beginner) in DanceType (Tap) and Lives in (Kansas, United States)
You have to understand what each of your Tables/Entities means and how they relate one to another.
The key to data base is to get your Tables and relationships designed so that they represent your "business".
Good luck with your project