We're a community of 1076K IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,075,708 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

Many-to-Many Relations, How to?

Hello,

Let's say I have 2 tables:

  • projects
  • users

and I need to relate them so that a user can work on one or more projects and a project can be worked by one or more users.

How to implement this without having a third table ?? It this possible??

2
Contributors
1
Reply
44 Minutes
Discussion Span
4 Months Ago
Last Updated
2
Views
Vincentas
Light Poster
31 posts since Nov 2012
Reputation Points: 0
Solved Threads: 1
Skill Endorsements: 0

How to implement this without having a third table ?? It this possible??

Not recommended. Third table is your best option. What would be the reason for not using one?

pritaeas
Posting Prodigy
Moderator
9,265 posts since Jul 2006
Reputation Points: 1,173
Solved Threads: 1,456
Skill Endorsements: 86

This article has been dead for over three months: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
 
© 2013 DaniWeb® LLC
Page rendered in 0.0644 seconds using 2.53MB