How do you create 2 key fields?

[Interesting Ian]

Hi,

Never used databases before. Just started about 30 mins ago. I'm following
this walkthrough in order to create a database, but on one table I am
supposed to to have 2 key fields. But it doesn't seem to allow me to do
this. It's Acess 2000. Any suggestions? Thanks.

[Mike MacSween]

"Interesting Ian" <sp**@doubtthouthestarsartfire.com> wrote in message
news:tF***************@newsfep4-winn.server.ntli.net...

Hi,

Never used databases before. Just started about 30 mins ago. I'm following this walkthrough in order to create a database, but on one table I am
supposed to to have 2 key fields. But it doesn't seem to allow me to do
this. It's Acess 2000. Any suggestions? Thanks.

Do you mean a primary key made up of 2 fields? In table design highlight two
fields by ctrl-clicking to the left hand side of them. Then click the key
icon on the toolbar. Viola! 'Tis done.

Mike

[Rick Brandt]

"Interesting Ian" <sp**@doubtthouthestarsartfire.com> wrote in message
news:tF***************@newsfep4-winn.server.ntli.net...

Hi,

Never used databases before. Just started about 30 mins ago. I'm following this walkthrough in order to create a database, but on one table I am
supposed to to have 2 key fields. But it doesn't seem to allow me to do
this. It's Acess 2000. Any suggestions? Thanks.

While in table design view, select one of the two fields and then hold the
control key down while selecting the second one. Now both fields are
highlighted and you can press the "Key" button in the toolbar to create a
composite Primary Key consisting of both fields.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Interesting Ian]

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:bo*************@ID-98015.news.uni-berlin.de...

"Interesting Ian" <sp**@doubtthouthestarsartfire.com> wrote in message
news:tF***************@newsfep4-winn.server.ntli.net...

Hi,

Never used databases before. Just started about 30 mins ago. I'm

following

this walkthrough in order to create a database, but on one table I am
supposed to to have 2 key fields. But it doesn't seem to allow me to do
this. It's Acess 2000. Any suggestions? Thanks.

While in table design view, select one of the two fields and then hold the
control key down while selecting the second one. Now both fields are
highlighted and you can press the "Key" button in the toolbar to create a
composite Primary Key consisting of both fields.

Hi, thanks :-)

[Mike MacSween]

"Interesting Ian" <sp**@doubtthouthestarsartfire.com> wrote in message
news:e9*****************@newsfep4-winn.server.ntli.net...

Pssst...think of a better on line name. Posting a question about a multi
field key really isn't THAT interesting <g>