create a unique index on all three columns, a subsequence insert of existing
combination should error out.
"Karl Raven" <lcaasia@pd.jaring.my> wrote in message
news:a1b1fs$t0a$1@news.tht.net...
> Hi,
>
> I'd like to create a table with 3 create unique fields :
>
> fields
> warehouseno,loc, productid, qty, qtyalllocated
>
> i'd like warehouseno,loc, productid to be unique..
> meaning
> 2000, ABC, X - ok
> 2000,ABC,Y -ok
> 2000,ABC,X - reject
> 2000,BCD,X - ok
>
> anyone knows how to do so?
>
> thanks
>
>
>
>