Re: check problem

On Thu, Feb 23, 2006 at 23:52:31 +0000,
  Luis Silva <lfs12@hotmail.com> wrote:
>
> tks for answering.
> Identity is the private key from the table. using your examples you could
> have :
> 1) ident1,1,'aaaa'
> 2) ident2,1,'aaaa'
> 3) ident3,2,'aaaa'
> 4) ident4,3,'bbbb'
>
> but not
>
> 5)identi5,1,'bbbb'
>
> -->same implicit_group for different privates.
> is it possible? tks again

The above table should only have the ident and the group number. The group
number should have a foreign key reference to another table of which the
group number is the primary key and another column for private.
This will allow only one private for each group number.