Thread: redo my design
View Single Post
  #5  
Old April 18th, 2010, 07:11 PM posted to microsoft.public.access.gettingstarted
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default redo my design

Why not take a couple seconds to explain which tables/fields you attempted
to create the relationships on? The person and group tables should each be
joined one-to-many to the Person Group table.

I hope the space in "Tbl PersonGroup" is just a typo. Avoid all spaces in
object names.

--
Duane Hookom
MS Access MVP


"shumate62" wrote in message
...
So, I made the three tables as suggested, tblPerson, Tbl PersonGroup,
TblGroup and then tried to create the relationship for them but it's stuck
on
only having a one to many relationship, which of course it isn't it's a
many
to many (there are multiple authors, and people belong to more than one
group) did I do something wrong in the formatting of the tables that
blocked
it from being a many to many?

"Steve" wrote:

You can do this with three tables ....
TblPerson
PersonID
name and address fields

TblGroup
GroupID
Group (author, speaker, speaker's guest, media, etc)

TblPersonGroup
PersonGroupID
GroupID
PersonID

TblPersonGroup gives you a list of persons in each group.

To print your labels, create a query that includes TblPerson and
TblPersonGroup. Include the name and address fields from TblPerson and
GroupID from TblPersonGroup. Set the recordsource for the labels to this
query. You can set the criteria of GroupID for the Group or groups you
want
to print.

Steve







"shumate62" wrote in message
...
I'm trying to build a database with minimal working knowledge of Access
so
even though I've been through the tutorial it seems way more
complicated
then
what I need. I have a list of people's name for an annual event and
basically
need an address book for mailing labels but I need to be able to sort
them
for about 10 different fields (author, speaker, speaker's guest,
media,)
but
some people belong to more than one group so if I do a print out of
labels
I
want to be able to select to just print 'media and speakers' etc. was
this
still supposed to be two tables joined together?



.