Error ORA-02270
<p>I'm very new to SQL and I've been stuck on this for a while.</p>

<p>Three out of my four tables have been created, but the last one keeps coming up with the 'no matching unique or primary key for this column' error. I have absolutely no clue how to fix this. </p>

<p>Below are the two tables that are causing the problem, the error comes up when I try to create the sessions table.</p>

<pre><code>CREATE TABLE SCREEN(
BRANCHID CHAR(2) NOT NULL,
SCREENID CHAR(2) NOT NULL,
SCREENCAPACITY CHAR(4),
CONSTRAINT SCREEN_PK PRIMARY KEY(SCREENID, BRANCHID),
CONSTRAINT SCREEN_FK1 FOREIGN KEY(BRANCHID) REFERENCES BRANCH(BRANCHID));

CREATE TABLE SESSIONS(
SESSIONID CHAR(4) NOT NULL,
BRANCHID CHAR(2),
SCREENID CHAR(2),
MOVIEID CHAR(2),
SESSIONDATE DATE,
SESSIONPRICE NUMBER(4,2),
CONSTRAINT SESSIONS_PK PRIMARY KEY(SESSIONID),
CONSTRAINT SESSIONS_FK1 FOREIGN KEY(BRANCHID) REFERENCES BRANCH(BRANCHID),
CONSTRAINT SESSIONS_FK2 FOREIGN KEY(SCREENID) REFERENCES SCREEN(SCREENID),
CONSTRAINT SESSIONS_FK3 FOREIGN KEY(MOVIEID) REFERENCES MOVIE(MOVIEID));
</code></pre>

<p>This is starting to get really frustrating so any help would be really appreciated.</p>