Only 1 record per...

[Guest_imported]

I have a one table with a primary key field. In addition to that it has a date and another identifier; along with a bunch of data that will be stored on a daily basis. This table is going to store data daily, however is there anyway I can make it so that for each identifier (not the key) that there is only one date?

For example: (datasheet view)

Key Indentifier Date Information
1 2002 2/28/02 28th info
2 3002 2/28/02 28th info
3 2002 3/01/02 1st info
4 3002 3/01/02 1st info

What I'm asking if there is any way to make sure that for every identifier there is only 1 date.

 

[loveTech]

if i am not mistaken... is it ok for it to have multiple identifiers?... but the dates should be the same for each of the identifier that are similar...

Key Indentifier Date Information
1 2002 2/28/02 28th info
2 2002 2/28/02 28th info
3 2002 2/28/02 1st info
4 2002 3/01/02 1st info
making key 4 invalid but 1-3 valid...

if so.. let me know

 

[Guest_imported]

This is an access database, I will look into this and see if I can figure that out. I tried real quick doing a search in Access help for 'multiple identifiers' and found nothing. I will keep looking. Thanks for the insight, if you come up with anything else, let me know.