Setting two fields as a unique combination 1

[jmob]

I have "TableB" that contains "idTableB"(Primary key), "descriptionB", "myDate".
The rule I would like to implement is: No two records with the same "descriptionB" and "myDate" should exist. I don't want these to serve as the primary key though. >>I know this may not be "normalized", but it is alright for now. thanks.

I think this is some simple answer of setting the keys up, but I am unsure on how to do it. Thanks.

 

[PHV]

You may create an unique composite index on (descriptionB, myDate)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MajP]

Create an index with both fields. Next to the primary key icon there should be a lightining bolt. In the first column give the index a name. In the second column list the first field, below it list the second field. Set the property to unique. The two have to be unique, but each one can repeat.

 

[jmob]

I have another question along the same lines. After I have created the unique combination, One of my fields is a date where I use the Now() function. I would like to limit the now to just a short date(10/17/2005).
Formatting the date to a short date only shows the date as short, but actually stores it with the time (e.g. 10/17/2005 12:00PM)
Is there a way to actually get it stored as just a short date.
Thanks again!

 

[PHV]

Use the Date() function instead of Now().

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886