Hi

I am playing with the trial version. I imported a VFP DB to a Lianja DB and now I want to duplicate VFP functionality for the database. The Lianja tables and indexes look fine however there is no code imported for the VFP Referential Integrity Builder which is where insert/update/delete triggers are defined.

My question is how would you code an OnBeforeDelete Table trigger to prevent deleting a parent record which is related to multiple child tables? Would you need to USE each child table and then SEEK the parent key?

For a test... From the Data workspace when I browse a parent table I do not want to be able to delete a record if child records exist.