Re: create table with multiple unique fields
Started by Ed Yuover 24 years ago1 messagesgeneral
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...
Show quoted text
Hi,
I'd like to create a table with 3 create unique fields :
fields
warehouseno,loc, productid, qty, qtyalllocatedi'd like warehouseno,loc, productid to be unique..
meaning
2000, ABC, X - ok
2000,ABC,Y -ok
2000,ABC,X - reject
2000,BCD,X - okanyone knows how to do so?
thanks
Import Notes
Reference msg id not found: a1b1fs$t0a$1@news.tht.net