RevMedia

(Tested on 1.16). There may be times when it is considered desirable to delete a record that contains relational keys linking it to other table(s). If a DELETE file rec_id command is issued, the record is deleted, but at the next "Updating Indexes" the system restores the record blank but for the related keys. In some ways this is desirable as it enforces a form of referential integrity but it can make things difficult.

Jim Owens was provided with a routine by Sprezzatura to do this but using the basic principles provided, refined the routine into that found below.

As Jim says "I'm not sure WHY it works!... but it works". What is probably happening is that the transaction record sequence is in some way being fooled by the rapid sequence of events. As this is the case there is a strong possibility that this will be rectified in a future release of the software, so if you use this tip, check it with every AREV upgrade.