On Fri, Oct 3, 2008 at 8:56 AM, Rob Richardson <Rob.Richardson@xxxxxxxxxxx> wrote: > No, because the application first saves the coils and then saves the > charge. Setting up the foreign key constraint would prevent any coils > from being saved because the charge record would never exist at the time > the coil record was created. You should be able to set your constraints to deferrable initially deferred and get proper behaviour even with that update system.