Re: DUPLICATE key in Index/Sql*Forms30

In article <sjsC9sywG.H6r_at_netcom.com> sjs_at_netcom.com (Stephen Schow) writes:
>Ron Olshavsky (rono_at_clark.net) wrote:
>: Farnham Dave (farnham_at_spot.Colorado.EDU) wrote:
>
>
>: : Scenario: I have four block in a screen.
>: : I am entering data for the FIRST time
>: : in blocks 1 and 2, and then in 3 referenciing
>: : an existing record in that table for that block,
>: : and then entering new data in block 4.
 

>: : By the way, these are all base table blocks.
 

>: : When I hit the commit key, Block 3 gives me an
>: : error saying duplicate key in index. I'm not
>: : trying to enter new data in block 3, just use an
>: : existing record that already exists in my table....
>
>I once had a similar scenario where I needed to have a master block
>and two parallel detail blocks that both pointed to the same database
>table. I wanted to do the same sort of thing, but I was having the same
>kind of problem. I was told by Oracle that having 'horizantal' detail blocks
>(as they reffered to it) was not supported in 3.0 but would be in 4.0

	I don't think this true, you can have more than one detail block
	for any master block. What I know is not possible is more than
	one master block for a detail block, which is really not needed 
	or can be worked around.