How to not allow a new record to have similar values as an existing one

[nosferatu26]

Hi, I am having an issue with duplicates in my table. I have a table, called "Part Mods", that has about 12 fields in it. the first 2 of them are "Mod" and "Part Number". I have a form where someone can insert data into this table and what i want is for them to NOT be able to insert a record with the same Mod/Part Number combination of an already existing record. I have "indexed" turned on but I am pretty sure that is for every field. I am trying to play around with the validation rule property but am having no luck.

If anyone can help me out i would appreciate it!!

 

[plog]

What you need is to assign a composite key to the table. Check out this link: https://support.office.com/en-sg/ar...mary-key-d61c9f21-accc-4566-ba3a-ea9bcffc06cf

With it, you assign multiple fields that designate a unique record and Access enforces it at the table level.

 

[nosferatu26]

thank you for the response and link. I am having trouble implementing it though. I am not very experienced with data definition queries/create index statements and I dont really know how to assign a compsoite key to the table. Any suggestions on how to approach this?

 

[plog]

In design view you hold the shift key and select the fields to be the composite key and then you right click and choose the Primary key option. That will assign it the ones you want.