|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 23rd, 2010, 01:11 AM
posted to microsoft.public.access.queries
|
|||
|
|||
key?
What record should i set my primary key to ?
|
|
#2
February 23rd, 2010, 01:28 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
key?
A primary key is a field or fields in your table, not a record. There are
lots of opinions on what type of field or fields to use. I almost always add an Autonumber primary key field to tables. -- Duane Hookom MS Access MVP "Carlos Santos" wrote in message ... What record should i set my primary key to ?
|
|
#3
February 23rd, 2010, 01:33 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
key?
On Mon, 22 Feb 2010 19:11:35 -0600, "Carlos Santos"
wrote: What record should i set my primary key to ? Sorry, but the question makes no sense. Every record in the table should have a Primary Key. This is one field (or more than one, up to ten fields) which uniquely identifies the record: only one record in the table can have that value of the PK. It also must be non-Null. Could you explain the current structure of your table, and just what it is that you are trying to accomplish? -- John W. Vinson [MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
