Hello. Let's say I have a table of colors (red, white, blue, etc.) and another table that has People's names, their favorite color, and their least favorite. I can't seem to set up TWO (or more) relationships between the table of colors to the Fav field and the table of colors and the Least Fav field. In Access, I believe you can do this (?) and Access would append _1 and _2, etc. to the tables in the Relationships diagram. But how to do this in SQL server? I keep getting a "you may have cascading issues" or some such warning in SQL server. Thanks!!!