Jeremy
----- Original Message -----
From: Dwayne Cole
To: CF-Talk
Sent: Saturday, January 31, 2004 10:10 AM
Subject: Re: DB design and CF question
sounds like a many to many relationship so you will need an associative table. one that relates project managers to clients and clients to project managers. Do you have something that looks like this?
TBL_MANAGER_CLIENTS
ID_CLIENT
ID_PROJECT_MANAGER
Dwayne Cole, MS in MIS, MBA
Florida A&M University
Certified Advanced ColdFusion Developer
850-591-0212
"It can truly be said that nothing happens until there is vision. But it is equally true that a vision with no underlying sense of purpose, no calling, is just a good idea - all "sound and fury, signifying nothing." The Fifth Discipline - Peter Senge
---------- Original Message ----------------------------------
From: "thinkcreate" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Sat, 31 Jan 2004 09:34:19 -0500
>This will undoubtly be simple for someone out there, but I have been out of the loop for some time now and am having trouble with my db design.
>
>My problem concerns two tables, one called PROJECTMANAGERS - which will have from 6 to 25 records in it. The second table is CLIENTS - 100 records or so. Primary keys and all that are fine. THe issue I am haveing is how would i be able to associate a project with a given set of project managers, so that when I query a client and put up that client it shows the 5 or 6 or 12 project mangers working with that client from the projectmanagers table. I am thing I would have to store the id's of the projectmanagers in the client;s table, but how would I do that not know how many a given client will have. is there someway I can store them all in one field of the clients table?
>
>
>
>
>Jeremy
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
