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
|
|||
|
|||
Beginners Question on Primary Key
Is there a way to set a primary key in the queries tab of Access? I would
like to set the primary key before I run my select query or make-table query. Is there a way to do this without having to go into the tables tab of the database window? A clue in the right direction would be very appreciated. Thank you. |
#2
|
|||
|
|||
Select queries run against established tables (and other queries). If those
precursors don't have a primary key, you won't get a primary key when you do a select query. A make table query doesn't provide a mechanism to designate a primary key, or to set one of the fields as an Autonumber data type via the query definition window. Scan this newsgroup for earlier posts concerning using code/VBA to set an Autonumber (but it isn't "beginner" level stuff). You've described a "how" -- if you explained a bit more about the "what" and "why", the 'group readers may be able to offer an alternate approach. -- Good luck Jeff Boyce Access MVP "The parawon" wrote in message ... Is there a way to set a primary key in the queries tab of Access? I would like to set the primary key before I run my select query or make-table query. Is there a way to do this without having to go into the tables tab of the database window? A clue in the right direction would be very appreciated. Thank you. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
another question regarding multiplep-field primary key | cwr | Database Design | 3 | August 17th, 2004 02:46 AM |
Another question | Lisa | New Users | 1 | August 9th, 2004 02:51 PM |
Primary Key not sorted | Mike | Database Design | 6 | June 16th, 2004 11:11 PM |
Muliple primary key | Billy K | Database Design | 4 | May 31st, 2004 02:50 PM |
Designing a question paper | Ken | New Users | 2 | April 28th, 2004 10:13 PM |