project managers. All it would contain is the UID�s from the other two
tables. Doing it this way gives you good flexibility. I hope that makes
sense.
I say minimum because in the needs you may have in the future it might also
be worth thinking about creating a projects table. In that case you can
relate the clients and project managers to the projects table. In that case
I would create two relate-link tables with UID�s. One containing projects
and clients, the other projects and project managers.
Kind Regards - Mike Brunt
Webapper Services LLC
Web Site http://www.webapper.com
Blog http://www.webapper.net
Webapper <Web Application Specialists>
-----Original Message-----
From: thinkcreate [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 31, 2004 6:34 AM
To: CF-Talk
Subject: DB design and CF question
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]
