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]
