Hi Sven,

I did not create a primary key. While we are on the topic. From your
experience, is it better to generate a unique key than use, say a composite
key of three values. In this case, PERSONID, OPTIONNAME and FUNDNO uniquely
identify a Fund policy.
CREATE TABLE "MEMBERINFUND"

(

"PERSONID" VARCHAR(15) NOT NULL,

"OPTIONNAME" VARCHAR(20) NOT NULL,

"FUNDNO" VARCHAR(20) NOT NULL,

"GROUPNAME" VARCHAR(30) NOT NULL,

"MARKETERID" VARCHAR(15) NOT NULL,

"DOI" DATE NOT NULL

);

ALTER TABLE "MEMBERINFUND" ADD FOREIGN KEY ("PERSONID") REFERENCES MEMBER
("PERSONID");

ALTER TABLE "MEMBERINFUND" ADD FOREIGN KEY ("FUNDNO") REFERENCES FUND
("FUNDNO");

ALTER TABLE "MEMBERINFUND" ADD FOREIGN KEY ("MARKETERID") REFERENCES PERSON
("PERSONID");

ALTER TABLE "MEMBERINFUND" ADD FOREIGN KEY ("GROUPNAME") REFERENCES GROUPS
("NAME");

----- Original Message -----
From: "Svein Erling Tysvær" <svein.erling.tysvaer@...>
To: <ibobjects@yahoogroups.com>
Sent: Monday, September 10, 2001 3:37 PM
Subject: Re: [IBO] error Singleton


> What is your primary key for MEMBERINFUND? For an edit to work, IB must be
> able to uniquely determine which record to update.
>
> Set
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>