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

Delete table row

Delete table row

How to delete a table row?

You can delete a table row. For example, go to the directory "branches" . There, right-click on the line that you want to delete, and select the command "Delete" .

Delete

Important Find out more about what are What are the types of menus? .

The deletion cannot be undone, so you will first need to confirm your intent.

Deletion confirmation

Delete multiple entries

Delete multiple entries

Note that in the confirmation message, the program shows in parentheses how many rows have been allocated. This means that multiple deletes are supported. If you need to delete several hundred entries, for example, you won't delete each one individually. It is enough to select all unnecessary lines once, and then click on the command once "Delete" .

Important See different ways to highlight lines .

And when you select several records, you can look at the very bottom at "status bar" how the program calculates exactly how many rows you have already selected.

Number of selected rows

Deletion Control

Deletion Control

After you confirm your intention to permanently delete a row, you still need to specify the reason for the deletion.

Reason for deletion

Only after that the line will be deleted. Or not removed...

Possible mistakes

Possible mistakes

The program contains internal data integrity protection. This means that you will not be able to delete an entry if it has already been used somewhere. For example, you cannot remove "subdivision" , if it has already been added "employees" . In this case, you will see an error message like this one.

Deletion error

Please note that the program message contains not only information for the user, but also technical information for the programmer.

Important See what error messages might appear.

What to do when such an error occurs? There are two solutions.

  1. You will need to delete all related records, such as employees who were added to the department being deleted.

  2. Or edit those employees by transferring them to another department.

Deleting 'global' rows that may be related to many other tables is a rather problematic task. But, by consistently reading this instruction, you will study the structure of this program well and will know about all the connections.

How to control all deletions?

How to control all deletions?

Important In a separate topic, you can read about how ProfessionalProfessional track all removals that users of the program have performed.

Delete access

Delete access

Important If your program configuration supports ProfessionalProfessional detailed setting of access rights , then you can independently specify for each table which of the users will be able to delete information from it.



See below for other helpful topics:

Your opinion is important to us!
Was this article helpful?



Universal Accounting System
2010 - 2024