Matthew Harris wrote:
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
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.26/748 - Release Date:
05/04/2007 15:33
Yes, providing you use the query facility to produce the report and both
"Date" and "Surname" are headings in your table.
Ron Ferguson
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
