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]
