Can I sort Records by date then Surname?
Thanks for the info.
On 4/4/07, Dan Lewis <[EMAIL PROTECTED]> wrote:
On Monday April 02 2007 10:42 pm, Matthew Harris wrote:
> You Database progam won't let me enter the same date in a different
> record, as guess because its in the Primary Key field.
> I want this field as the Primary Key, AND I want this field to
> sometimes be the same date.
>
> PLEASE FIX THIS
Sorry, but you can not have it. Base creates relational
databases, and they have specific requirements. One of them is that
the Primary key must be a unique value for each record of the
database. If you are going to have the same date in more than one
record, you CAN NOT use that date field as the Primary key for the
table unless you have another field in that table which when used
with the date is a unique value. You would be better off creating a
primary key in this table instead of using the date field.
Dan
