Re: Multiple Primary Keys
- From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 13 Oct 2005 15:42:39 -0600
On Thu, 13 Oct 2005 11:09:04 -0700, "Liz Gronewold" <Liz
Gronewold@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>When I have two primary keys on my table,
No, you don't. <Highlander>There can only be one!</Highlander> A table
can have one and only one primary key; that key might consist of one,
two, or ten fields, but it's only the one key.
>when the table is shown, the
>"field" area for the first key is nowhere near big enough.
In the table datasheet?? Two suggestions: one, use the mouse, click at
the right edge of the field that's too small, drag it right, and save
the table; and - better - don't use table datasheets for any routine
viewing or editing; use a Form instead.
> Both fields are
>set to a size of 50 characters; one is a SSN (1st field, 11 characters),
so why are you allocating 50 characters if you'll never have more than
11?
>and the other is a date (2nd field, 10 characters).
If it's a Date/Time field, it's not actually stored as characters;
it's stored as a number, formatted to look like a date.
>Why can't I just adjust the
>size of the first field like I can a column?
I'm not at all sure what it is you're trying to "adjust".
John W. Vinson[MVP]
.
- Prev by Date: Re: how to do mass merge docments into a letter head template
- Next by Date: Re: jpeg images not showing in my access forms
- Previous by thread: Re: Multiple Primary Keys
- Next by thread: Access Query Question
- Index(es):
Relevant Pages
|
