I have two tables : User table and Forum table. They are many to many relationship.
I create tables in Access.
So I create a bridge table -- usergroupline table. The primary key are userid and forumid from the other two tables.
The problem is that the user only can join one forum. But I want one user can join more than one forum. What did I do wrong?
I create tables in Access.
So I create a bridge table -- usergroupline table. The primary key are userid and forumid from the other two tables.
The problem is that the user only can join one forum. But I want one user can join more than one forum. What did I do wrong?