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 |
|
spmchugh82
Starting Member
13 Posts |
 Posted - 2009-02-17 : 19:21:57
|
| Hi, I'm stupid. I need help again. Here is a picture that shows what I'm working with: http://www.seansbagoftricks.com/uploads/compositePK.jpgThe Pizza column in the Pizza table needs to reference the Pizza column in the Used Ingredients table and the Ingredients column in the Ingredients table needs to reference the Ingredients table in the Used Ingredients table.In other words, how to I reference a composite primary key if the foriegn key is only part of the composite primary key???If you look at the picture you'll understand what I'm saying.Thanks in advance! |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
spmchugh82
Starting Member
13 Posts |
Posted - 2009-02-17 : 19:34:08
|
| pizza------>(pizza|ingredient)<-------ingredientthats what i want to do |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
spmchugh82
Starting Member
13 Posts |
Posted - 2009-02-17 : 19:58:53
|
| Okay, thanks guys. I tried yours Tara and got it to accept the commands after changing things around. Yep, I had it backwards anyhow.THANKS EVERYONE! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
How do I create create this relationship?