Whoever Posted August 24, 2003 Share Posted August 24, 2003 Suppose I have a table TASKS, that contains, well, tasks and related information, such as name, startdate, enddate, infotext and such. And I have another table USERS that contains user information, such as..well, what usually goes into a USER table. Now Im trying to find some way of having a TASK have multiple users associated AS WELL as a USER having multiple tasks associated. Any idea how to do that? Thanks in advance Quote Link to comment Share on other sites More sharing options...
effigy Posted August 24, 2003 Share Posted August 24, 2003 something like this, i believe: users: ===================== | userid | username | ===================== | 1 | bob | ===================== tasks: ===================== | taskid | taskinfo | ===================== | 1 | mop | ===================== | 2 | vacuum | ===================== assignments: ============================== | assignid | taskid | userid | ============================== | 1 | 1 | 1 | ============================== | 2 | 2 | 1 | ============================== Quote Link to comment Share on other sites More sharing options...
Whoever Posted August 24, 2003 Author Share Posted August 24, 2003 thanks effigy, I actually got the same answer from another person about 30 minutes ago, but its nice to see it validated! Thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.