How do you create 2 key fields?

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.

"Interesting Ian" <spam@doubtthouthestarsartfire.com> wrote in message
news:tFvpb.1647$382.13@newsfep4-winn.server.ntli.net...[color=blue]
> Hi,
>
> Never used databases before. Just started about 30 mins ago. I'm[/color]
following[color=blue]
> 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.[/color]

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

"Interesting Ian" <spam@doubtthouthestarsartfire.com> wrote in message
news:tFvpb.1647$382.13@newsfep4-winn.server.ntli.net...[color=blue]
> Hi,
>
> Never used databases before. Just started about 30 mins ago. I'm[/color]
following[color=blue]
> 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.[/color]

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

"Rick Brandt" <rickbrandt2@hotmail.com> wrote in message
news:bo62b6$18oaf6$1@ID-98015.news.uni-berlin.de...[color=blue]
> "Interesting Ian" <spam@doubtthouthestarsartfire.com> wrote in message
> news:tFvpb.1647$382.13@newsfep4-winn.server.ntli.net...[color=green]
> > Hi,
> >
> > Never used databases before. Just started about 30 mins ago. I'm[/color]
> following[color=green]
> > 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.[/color]
>
> 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.
>[/color]
Hi, thanks :-)

"Interesting Ian" <spam@doubtthouthestarsartfire.com> wrote in message
news:e9ypb.1831$382.1138@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>