title: Oracle composite primary key / foreign key question
body: <p>I have a composite primary key in 1 table in oracle.  I want to create a foreign key for one table entry in my second table that references the composite primary key in the first table.  I am getting the error ORA-02256.  Any thoughts on how I can enter this?</p>
  
  <pre><code>CREATE TABLE groupspersonx ( 
    personid number, 
    groupid number, 
    CONSTRAINT pk_persongroupid PRIMARY KEY(personid, groupid) 
  ); 
  
  CREATE TABLE restrictedgroups ( 
    groupid number, 
    name varchar2(50), 
    dateadded date, 
    since date, 
    notes varchar2(1024), 
    CONSTRAINT pk_groupid PRIMARY KEY(groupid), 
    CONSTRAINT fk_persongroup FOREIGN KEY(groupid) REFERENCES groupspersonx(personid, groupid) 
  ); 
  </code></pre>