Designing Groups

[Mervyn Thomas]

Please could someone help me get started. I have a standard MS contacts
table which has a "type of Contacts" table linked to it so that when I add
contacts I can select what type of contacts they are. That works fine. In
addition I want to put the same contacts into a series of groups each with a
leader, venue etc. How do I go about defining the extra table and joins
etc and what is the best way to enter the contacts into their groups. I
thought it was going to be easy but I am going round in circles!!!

 

[strive4peace]

Hi Mervyn,

it is hard to answer your question because you are asking what
additional tables you need, but you have not specified what you already
have...

Warm Regards,
Crystal
remote programming and training

*
have an awesome day
*
~~~~~~
Learn Access on YouTube!
http://www.youtube.com/user/LearnAccessByCrystal
~~~~~~
Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace
~~~~~~

 

[Mervyn Thomas]

Hi Crystal - I have a contacts table with 15 fields or so of persoanl data.
There also is a 2 field "type of contacts" Table which is joined to contacts
as one contact to many "types of contact"
I know I need a "Group" table but don't know how to join it to contacts so
that a particular contact can be a member of one or more groups. (Many to
Many). The report I want out is a sort by group giving the members in the
group and who their leader, venue is etc.
I do hope this clarifies!
Thanks
Mervyn