Access Database, Duplication of Records

Navigation
0

In an Access BD with fields ID (automatic numbering), EMPLOYEE, DATE, QUANTITY, the data is collected daily (in a single message) via Outlook. So, is it possible to prevent the same employee from having two records in the DB with the same date? Please, if possible, I need to learn, help me. You have to prevent the employee from sending the same message twice or more. For example.:

    
asked by anonymous 12.07.2016 / 16:46

1 answer

0

Use the code below:

ALTER TABLE [your_table] ADD CONSTRAINT uniq_register UNIQUE ([EMPLOYEE], [DATA])

    
13.07.2016 / 12:02
Error inserting record into daughter table with PHP Modeling bank with Inheritance with JPA