USU  ››  Programs for business automation  ››  Program for clinic  ››  Instructions for the medical program  ›› 

Can duplicates be entered?

Error when trying to add a duplicate

Can duplicates be entered? Duplicate entries are not allowed!

If you have, for example, some "employee" with a certain "name" , then an attempt to add a second one of the same type is most often a user error due to inattention. Therefore, the ' USU ' program will not miss a duplicate.

Uniqueness can be configured for any field or value, if necessary, to order, if you need to limit this for some fields. But for most important values, it has already been added.

See what error comes up when you try to save a duplicate. And also - and other possible errors when saving .

What if a duplicate is needed?

If by some miracle it turned out that two full namesakes work in your company, in this case "full name" the second one needs to be introduced with a slight difference, for example, with a dot at the end or add a notation that you understand. Keep in mind that in this case it is necessary that you can easily understand when choosing which of the two similar records you are choosing.

For the program, duplicates are most often not a problem, since each record has its own unique code in the database. The difference is necessary for the user of the program, so that he can correctly distinguish the records from each other and not choose his full namesake instead of one client.

The same principle is used when employees are often lazy and do not write down the full details of the client. Checking for duplicates will force such workers to enter everything correctly.

Unique number

It is also convenient to identify employees or customers by a unique code .

So customers in a pharmacy can be found by phone number or discount card, and a patient can be found by medical card number.

Highlighting Duplicate or Unique Values

Duplicate values can occur in fields that are not key. For example, the same patient may make many appointments with a doctor. See how to highlight regular customers .

See below for other helpful topics:

• Types of errors
• Unique identificator
• Find duplicates in a column
• To the begining

• Download the program with interactive training