Hello Mike,

a> No, the mastuser table is the parent, basket is the child. It's a one
a> to many relationship.
a> I want the constraint in so that if I delete a mastuser record, all
a> corresponding basket records will be deleted as well.
Martijn try to say that you have to define PRIMARY KEY or UNIQUE
constarint on (ACCOUNT, USER_NAME) for mastuser firstly, then commit,
then define FOREIGN KEY for basket (with ON DELETE CASCADE), and
commit.


HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com