Subject Re: [IBO] error Singleton
Author Svein Erling Tysvær
Hi Dion,

>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.

When I studied, I learnt to use a composite key. But that was a long time
ago and I've grown to appreciate using generators to populate a single
(meaningless) value for the primary key. So my advice is to add another
field and use that as your PK.

Do this, include the PK in your SELECT and your edit ought to work,