primary key on two fields

[buddyr]

Hello,
I have an access database w/one table- one form.
I want to make first two fields have primary key. I select them in design view of table and use primary key icon.
But it is not working like I thought it should.
field1- ONE field2-DATE
If I enter same data in ONE and different data in DATE- I thought it should it should allow me- It does not.
I thought It would only stop me if I tried entering same data in both fields.Could the DATE field be a problem? or is that not how to do this?

Is there a way to do this?
Thank you

[ADezii]

Hello,
I have an access database w/one table- one form.
I want to make first two fields have primary key. I select them in design view of table and use primary key icon.
But it is not working like I thought it should.
field1- ONE field2-DATE
If I enter same data in ONE and different data in DATE- I thought it should it should allow me- It does not.
I thought It would only stop me if I tried entering same data in both fields.Could the DATE field be a problem? or is that not how to do this?

Is there a way to do this?
Thank you

What you are referring to is a Composit Primary Key (Primary Key conisting of Multiple Fields) and this is the easiest way to create one:

• Select the Table to contain the Primary Key ==> Design View
• Select View ==> Toolbars ==> Table Design
• Select your Fields that will make up this Composite Key by holding down the CTRL Key and clicking on the Fields
• On the Table Design Toolbar, click on the Primary Key button (it is between the UNDO and Indexes button)
• Good luck

[buddyr]

thank you
Not sure what I was doing wrong - works fine now

[ADezii]

thank you
Not sure what I was doing wrong - works fine now

Glad to help.