AnsweredAssumed Answered

Error creating child records in related table

Question asked by disabled_JustinClose on Apr 10, 2013
Latest reply on Apr 11, 2013 by philmodjunk


Error creating child records in related table


     I am trying to set a field in a related table, via a script, but am getting this error:

     "This operation cannot be performed because one or more required related records are not available and cannot be created."

     TableB::ID <=> TableA::ID <=> TableC::ID

     The script is running in a layout based on TableB.  I am trying to have set a field in TableC, so it is looking through TableA to set a field in TableC.  The related records in TableC DON'T previously exist, but I have 'Create records based on this relationship' checked in the relation from TableA to TableC, just for this purpose. 

     In my dataviewer I see:

     TableB::ID = 1111

     TableA::ID = 1111

     TableC::ID = ""

     Anyone have ideas what's going on here, why I can't create the related records?


     --  J