Supervisor utilities > Relations

Recover functions are all related to the relation management files, F90 (containing personen and firmas),personen and firmas.

These functions can be started from the Supervisor menu, option Recover functions.

In the appearing screen five different functions can be activated and will be described below:

1. Recover table numbers

2. Recover F90

3. Delete empty table codes

4. Delete empty relation codes

5. Delete floating records

All functions can be activated together by activating the check box.

Important: Before executing one or more functions, make a back up first!

1. Recover table numbers

This functions checks all table numbers in existing files of relation management. If necessary these table numbers will be recovered on the basis of table numbers in the file layout.

2. Recover F90

All entered persons and companies are saved in file F90. This file is built up on the basis of files "Personen" and "Firmas". This function compares the values in F90 with the Personen- and Firmas file. If values of F90 appear in these two files the values of these two files will be set to F90. If the values of F90 do not appear in the Personen- and Firmas-files, values will be set in these two files.

Next, the Personen- and firmas-file will be checked on code and compared with the code in F90. If codes do exist in Personen or Firmas and do not exist in F90 a new record will be created in F90.

3. Delete empty table codes

In relation management tables can be maintained by the user. For example, in file "Contract partners" the type can be maintained in a list. The entered code and description will be saved. On top of that the table number and the description of this type will be saved.

If this function is executed, Mill7 checks if records exist with no table number. If such a record exists it will be deleted.

4. Delete empty relation codes

With this function the files Personen and Firmas will be checked on field "code". If no code exists in a record, the record will be deleted.

All relation management files will be checked. If a record exists from which field "firma" (containing the code) is empty the record will be deleted.

For each record in relation management files a field (named creation) exists, often used in reports to link to Notes.

This code must be unique, and will be made unique if duplicates are found. The creation code in the Note linked to the relation management record will also be changed.

5. Delete floating records

This function checks all records of relation management files (F110 until F145), mailing, notes and documents.

If records exists in these files with no existing relation code in file F90 this record is a floating record.

By executing this function these floating record will be deleted. The function "Recover F90" will be activated automatically.