Re: Quick "unique" question...

2003-04-01 Thread gerald_clark
Why don't you try it yourself. You could have tried it in less time than it took to mail the question. The manual works too. I'm not going to answer because you need to learn how to learn. Noel Wade wrote: I know its possible to use multiple fields for the primary key in a table i.e. "primary ke

Re: Quick "unique" question...

2003-04-01 Thread Noel Wade
AIL PROTECTED]> Sent: Tuesday, April 01, 2003 12:04 AM Subject: Quick "unique" question... I know its possible to use multiple fields for the primary key in a table i.e. "primary key(foo,bar)" Is it possible to do this with "unique" identifiers as well? Like &qu

re: Quick "unique" question...

2003-04-01 Thread Egor Egorov
On Tuesday 01 April 2003 09:04, Noel Wade wrote: > I know its possible to use multiple fields for the primary key in a table > i.e. "primary key(foo,bar)" > > Is it possible to do this with "unique" identifiers as well? Like "unique > key(foo,bar)" ?? > > I already have a primary key on a table,

Quick "unique" question...

2003-03-31 Thread Noel Wade
I know its possible to use multiple fields for the primary key in a table i.e. "primary key(foo,bar)" Is it possible to do this with "unique" identifiers as well? Like "unique key(foo,bar)" ?? I already have a primary key on a table, but I'd also like to force two fields to form a unique comb