By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,939 Members | 611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,939 IT Pros & Developers. It's quick & easy.

Using a key based on 2 fields

P: n/a
I there a way in Access to make the primary key a combination of two
fields, or is this something that would have to be done
programmatically from a front-end application?
---Atreju---
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Atreju" <so*****@who.hates.junkmail> wrote in message
news:3f********************************@4ax.com...
I there a way in Access to make the primary key a combination of two
fields, or is this something that would have to be done
programmatically from a front-end application?


Hold the <control> key while selecting the desired fields (in design view) and
then press the "key" button on the toolbar.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
Open the table in Design mode.
Highlight all of the fields you want to have in the primary key (you can
have up to 10)
Click on the Key icon to set the primary key.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Atreju" <so*****@who.hates.junkmail> wrote in message
news:3f********************************@4ax.com...
I there a way in Access to make the primary key a combination of two
fields, or is this something that would have to be done
programmatically from a front-end application?
---Atreju---

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.