create table with composite fk's?

[IBazz]

Hi, I am trying to create a table where two of the fields form a composite PK in the parent table.

should the referring fk's be referred as a pair or individually.

, CONSTRAINT rs_category_fk
   FOREIGN KEY (facility_category,facility_name)
     REFERENCES facilities_rooms_mainlist (facility_category,facility_name)

It errors as it is now but I thought they should be 'paired'
bazz

[IBazz]

got it resolved. the primary key of the parent tbale had three values so I needed to realise that and then add the third one to the referencing constraint

bazz