Delete Records

In Names, Course, Registrations, Instructors, Firms, and Locations screens, the Delete options are available on the Admin tab of the screen.

Other areas like Payments, Catalog, Codes, etc., the Delete button is on the screen.

WARNING

You must have Student Manager Administrator access rights to delete records.

VFP Database Users

• In VFP databases, records are marked for deletion and are not removed from the data tables until you run the Pack procedure.

• Deleted records do not appear in Find routines.

-You can undelete selected Pay records from the F7 Pay Grabber tool --IF-- you haven't run the Pack procedure yet.

SQL Database Users

In SQL databases (both MSSQL and PostgreSQL), records are immediately removed from the data tables.

Parent Records

You CANNOT delete 'parent' records until you have deleted all associated 'child' records.

For example, you cannot delete a Name record if the individual has enrolled in courses. You must first delete the registration records then you can delete the Name record.

Delete Course/Room Use

If you delete a course record, all the associated Room Use records are removed from the system.

If you restore the course record, you must recreate the Room Use records for the course:

1. Click into the Sessions field.
2. Re-enter the number of sessions.
3. Tab out of the Sessions field.
4. Save the course record.