No duplicates in several fields

[dawnd3]

Hi All, I think I know the answer to this, I just want to verify. I have a table in my access database that tracks donation records. I would like to program it so that it will not allow a duplicate record from the same person, on the same date, with the same donation type and same amount. Any of those individually can be duplicated, just not all 4. How do I accomplish this. My thought is that I just make all 4 fields a primary key in the table? If that is the case, what happens to the current primary key of Donation ID? Please let me know if I am on track or off base.

Thank you,

Dawn

http://www.calliopeconsulting.net

 

[lespaul]

no, just add a unique index comprised of those four fields...you don't have to make them the PK...

Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com