>I created a database with about 38 tables and have been experimenting with data conversion loads from 2.6. My procedure is to create a load program, load the data, index the table, set up referential integrety between the new table and several lookup tables (having cascade, restrict, restrict as the parent child options), and perform several test on the data. When I find a problem with the table structure or my normalization methods, I make modifications to the table and do the above again. My question is this, I use the Database designer to remove my referential integrety between the tables (highlighting the line connecting the tables and pressing the delete key). What I have been finding is that the insert and update triggers are not removed from the table and my load programs fail. I have to manually delete the triggers in the tables to get rid of them. Am I doing something wrong here (order wise) or does VFP have a problem with cleaning up after itself when referential
>integrety is removed?
>
>TIA

To get rid of triggers you should rebuild RI, clicking Ok in RI Builder, i.e. you can just set appropriate rule to Ignore and rebuild without removing links.