Dan Lewis 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
And it is the same with any Relational Database product no matter who
makes it.
If you need the date to be the key, then add time to it as well, this
way it will be unique as the time should be different.
Also, you can make an ID number as your primary key and do a query for
the records that have the same date.
I ran into this problem with Paradox back in the DOS days and I was
learning.
--
Due to the move to M$ Exchange Server,
anything that is a priority, please phone.
Robin Laing
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
