Designing Groups

M

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!!!
 
S

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/LearnAc...url]http://www.AccessMVP.com/strive4peace~~~~
 
M

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




strive4peace said:
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/LearnAc... am going round in circles!!![/QUOTE][/QUOTE]
Click to expand...
 
Top