Re: What generates FRM-41106 Cannot create record without parent?
From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 29 Jul 2005 09:09:00 -0700
Message-ID: <1122653310.320581_at_yasure>
>>"Miggins" <mtproc_at_yahoo.co.uk> wrote in message
>>news:1122386902.219502.294610_at_g44g2000cwa.googlegroups.com...
>>
>>>Each,
>>>
>>>Am getting this error from a form. I know what the error means am just
>>>wanting to know what generates this error. It is not coming back from
>>>the server as there is no referential integrity between the 2 tables on
>>>the server.
>>>
>>>What prompts forms to generate this error?
>>>
>>>Thanks
>>>
>>
>>FRM errors come from FORMS
>>
>>you apparently have a master/detail relationship and you are trying to
>>insert a new record into the detail block when there is no record current in
>>the master bloack
>>
>>++ mcs
Date: Fri, 29 Jul 2005 09:09:00 -0700
Message-ID: <1122653310.320581_at_yasure>
[Quoted] Miggins wrote:
> i know and understand that....am trying to determine were the code is > that generates this error message. is it something generated implicitly > by forms? > > > Mark C. Stock wrote: >
>>"Miggins" <mtproc_at_yahoo.co.uk> wrote in message
>>news:1122386902.219502.294610_at_g44g2000cwa.googlegroups.com...
>>
>>>Each,
>>>
>>>Am getting this error from a form. I know what the error means am just
>>>wanting to know what generates this error. It is not coming back from
>>>the server as there is no referential integrity between the 2 tables on
>>>the server.
>>>
>>>What prompts forms to generate this error?
>>>
>>>Thanks
>>>
>>
>>FRM errors come from FORMS
>>
>>you apparently have a master/detail relationship and you are trying to
>>insert a new record into the detail block when there is no record current in
>>the master bloack
>>
>>++ mcs
Yes. When Forms creates parent-child relationships between blocks it writes triggers and procedures.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Fri Jul 29 2005 - 18:09:00 CEST