SQL*Forms 3.0 / MasterBlock & Join Clause

I have the following tables:

> MSLICENSES "Multi-State Licenses"
>
> Name Null? Type
> ------------------------------- -------- ----
> LICENSEEID NOT NULL NUMBER(7)
> FNAME NOT NULL CHAR(30)
> LNAME NOT NULL CHAR(30)
> MNAME CHAR(30)
> BIRTHDATE DATE
> IDNO NOT NULL NUMBER(10)
> IDTYPE NOT NULL NUMBER(4)
> ENTRYDATE DATE
> DATERECEIVED DATE
> DATEPROCESSED DATE
> RETURNED CHAR(3)
> FINGERPRINT CHAR(3)
> COMMENTS LONG
>
> MSLICENSES "Multi-State Licenses"
>
> Name Null? Type
> ------------------------------- -------- ----
> LICENSEID NOT NULL NUMBER(7)
> LICENSEEID NOT NULL NUMBER(7)
> LICENSETYPE NOT NULL NUMBER(4)
> ISSUEDATE NOT NULL DATE
> DIVISION NOT NULL NUMBER(4)
> STATE NOT NULL CHAR(3)
> COMMENTS LONG
I want to create a form in SQL*Forms 3.0 that shows the LICENSEE'S data with a list of his/her licenses on file. My first form block is called LICENSEE which contains the liscense's data. My second form block is called LICENSES which contains license information.

Creation of the LICENSEE block is easy. However, when I create the second block, LICENSES, and enter the master block and join clause I get the following Oracle error:

> FRM-20077: Invalid join condition. (Valid syntax: field1 = field2 and ...)

My Master Block is set to LICENSEE and my join clause is the following:

> LICENSES.LICENSEEID = LICENSEE.LICENSEEID
This seems far to easy to cause an error. Have I missed something? Also, is there a way to edit a blocks Master Block after it has already been created?

---
Neil Greene
ARCI, Inc.
Kentucky NeXT User Group, Inc.
Phone: 606.254.4060
Fax: 606.254.4864
Email: deepthought!neil_at_ms.uky.edu


-- 
Neil Greene
ARCI, Inc.
Kentucky NeXT User Group, Inc.
Phone: 606.254.4060