Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Anybody?
Dereck L. Dietz wrote:
> "DA Morgan" <damorgan_at_psoug.org> wrote in message
> news:1145222951.39386_at_yasure.drizzle.com...
>> Dereck L. Dietz wrote: >>> Is there anybody who will try to help me with this problem? I'm at a >>> complete loss at to why forms is requiring at least one batting record
>>> exist while it does not require at least one pitching record to exist
>>> have both blocks set up the same way with the only differences being the >>> table they are based on. >> Glad to help you. >> >> What version of Forms?
>> How many data blocks in the form?
>> How are they related?
Thanks for trying to provide the information but I can see I was very unclear in what I asked for. What I mean by the relationship between the blocks was the following (following instructions based on version so your path may vary):
Open the form in Form Builder
Click on DATA BLOCKS
Click on the first block
Click on Relations
Double click on the first relationship
Click on Join Condition in the Property Palette
Copy the contents. That is how the Form thinks the blocks are related.
To cut to the chase the problem most likely (not definitely) comes from the nature of the relationships between the blocks OR from a trigger that is modifying one of the blocks when the form is opened or the block becomes the current block.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Mon Apr 17 2006 - 10:53:09 CDT