I'm trying to get my head around how this works. I have two tables where
there is a foreign key relationship between the two tables. I've created a
constraint to show this relationship and that works fine.

But I now need to change a property of that constraint (from 'No Update' to
'Cascade') in the case of a delete. When I attempt to make this change with
IBExpert, I'm getting an error 'XXXXXX in use'

What do I need to do to be able to make these sorts of changes and not
encounter these errors?

Myles


============================
Myles Wakeham
Director of Engineering
Tech Solutions US, Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
www.techsol.org