Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-02 : 07:28:49
|
| john writes "hi!I am using WIN XP-PROF, sql-2000. I stuck with a problem.I designed tables like the ones below ..Personal Details tableMemberID Name Tel Fax 1 Karthik 0201... 1240..2 Watson 02081.. 1245..3 Andrew 343... 3444.......and so on for ten more members (say).and other table goes like this Selected Credits tableCreditID Title Director Description1 Band Aid 20 Karthik 60mins Documentary.Channel 42 Cosmic Relief Karthik 60mins Documentary.BBC TV3...4...5...6...This is a CV design page of directors. Now each candidate can enter as many selected credits as they like say maximum 6 or 7.So if karthik has directed 6 films (say)and Watson has directed 5 films (say) and so on the rest . My Question is how should i relate each person with his own selected credits. I need to display his CV with all his selected credits and personal details. I need to do for 50 people like that . I cant relate them in any way to extract the information of single person. Are there any ideas to solve this problem. I would really appreciate your help thanks in advance.John " |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-05-02 : 13:42:52
|
| I'm not sure I understand the problem but... If each row of the selectedCredits table can only belong to 1 MemberID then you could add MemberID (as a foreign key) to the SelectedCredits table.If 1 row of the selectedCredits table can belong to more than one MemberID then you will need an association table ie: MemberCredit (memberid, creditid)Is that what you're looking for?EDIT:As far as your "problem with relationships", join the club.Be One with the OptimizerTG |
 |
|
|
|
|
|
Problem with relationships