I have a very simple ? about relationships in sql srv 7. I have a lookup table 'WhyCodes' that has a 2 field pk 'Why' + 'Location'. This table is used as a lookup for another table 'ShiftDown' for downtime entries. This table 'ShiftDown' contains the 'Why' field as a fk from the 'WhyCodes' table. I initally just had the 'Why' field as the primary key without the 'Location' participating in the relationship. However, I am adding another location that will also be using the 'WhyCodes' table and I need to add many of the same 'Why' codes for that location also. The 'Why' field may be entered multiple times with a different location. It needs to be this way because the 'WhyCodes' table also has a field called 'Active' that allows a plant to deactivate a 'Why' code and not have it show up in THEIR lookups etc. My problem is I cannot create a relationship between my 'ShiftDown' tables 'Why' field and my 'WhyCodes' table 'Why' field because my pk in the 'WhyCodes' table contains 2 fields? I still want to have the 'ShiftDown' 'Why' field required to be in my 'WhyCodes' table? Is there anyway to do this with a relationship?