If we go, for example, to the directory "employees" , we will see that the field "ID" originally hidden. Display it please. This is the unique identifier.
Now, next to the name of each employee, an identifier will also be written.
Field "ID" is the row ID. In every table, every row has a unique number. This is necessary both for the program itself and for users. Moreover, it can be useful for users in a variety of cases.
For example, in your list "patients" two people with the same "surname" .
See if duplicates are allowed in the program?
To specify a certain person, one employee can say to another: ' Olga Mikhailovna, please print out the payment receipt for patient No. 75 '.
The same can be said just to speed up the process. After all, you can navigate by a short number much faster than by the name of an organization or the full name of a person.
Using the 'ID' field, it is much faster to search for a specific record.
Thus, you can use an identifier from any table in a conversation. For example, from the table "Visits" . So, Olga Mikhailovna can answer: ' Nastenka, yesterday the receipt was printed out for reception No. 555 '.
Find out how Olga Mikhailovna with the help the audit can find out the date of formation of any document in any table.
If you sort records in any table by the ID field, they will line up as users add them. That is, the last added entry will be at the very bottom of the table.
And it is the 'ID' system field that counts the number of records in a table or group.
See below for other helpful topics:
Universal Accounting System
2010 - 2025