Dick Bannister
New member
- Local time
- Tomorrow, 08:26
- Joined
- Feb 6, 2009
- Messages
- 1
I am working on a database for a Church, containing (among other things) a household table (address, surname, etc) and an individuals table (Firstname of people in the Household plus individual data such as mobile phone #, etc). These tables are linked together.
I now want to associate individuals with roles (eg sound, website newsletter, etc) These roles are listed in a table called roles. This creates a many to many situation since each individual can have many roles and each role can have many individuals.
I have created a junction table between the individuals and the roles and have a form (individuals with the junction form as a subform) to put roles against individuals and this works fine. The trouble is that there is no Surname in the individuals table, so it is hard to figure out the person required.
I have therefore tried to relate a query (made from household and individuals tables) which has First name and Surname in it, with the roles table, and this does not work.
I have reached the stage where I'm not sure what to try and would appreciate any clues.
I now want to associate individuals with roles (eg sound, website newsletter, etc) These roles are listed in a table called roles. This creates a many to many situation since each individual can have many roles and each role can have many individuals.
I have created a junction table between the individuals and the roles and have a form (individuals with the junction form as a subform) to put roles against individuals and this works fine. The trouble is that there is no Surname in the individuals table, so it is hard to figure out the person required.
I have therefore tried to relate a query (made from household and individuals tables) which has First name and Surname in it, with the roles table, and this does not work.
I have reached the stage where I'm not sure what to try and would appreciate any clues.
