Relation?

Hi,

If I have 2 tables:

[Table_Users]
PK_ID
Name
GroupID

and

[Table_Groups]
PK_ID
GroupName

Now, a single user can join multiple groups.
How can I do this, using the "Relations" option in Access?

For example: the user "John Smith" can join the group "Friends" and also the group "Classmates".

I don't realy know how to do this. Please help!
(How can John Smith add multiple GroupID's?)

Thanks in advance!
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories