Wrox Programmer Forums
BOOK: Beginning Oracle Application Express ISBN: 9780470388372
This is the forum to discuss the Wrox book Beginning Oracle Application Express by Rick Greenwald; ISBN: 9780470388372
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Oracle Application Express ISBN: 9780470388372 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old November 22nd, 2010, 02:48 AM
Registered User
Join Date: Nov 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default master-detail foreign key

hello i just start using application builder in oracle 10g and now i'm stuck with master-detail foreign key problem...

in chapter 2 we create master-detail for order - order item and all column for master and detail are selected to be displayed.... after finished all this master -detail form... i got a different result..

when i click edit for order... the order item show the order_id but in the book not showing any order_id...
then when i click create.... in the book only have 3 textfield(product_id, unit price, quantity) but my result show 4 textfield(order_id, product_id, unit price, quantity)...

if i'm not include order_items.order_id as displayed column then everything will look same but if i'm inserting new record.... the order_id will be null...

what should i do to make it work properly??


Similar Threads
Thread Thread Starter Forum Replies Last Post
Foreign Key issues with framework when starting several packages from a master. cmarcum BOOK: Microsoft SQL Server 2008 Integration Services Problem-Design-Solution 5 February 20th, 2012 12:50 AM
Foreign key not updating with Primary key xavier1945 BOOK: Access 2003 VBA Programmer's Reference 2 July 4th, 2007 09:48 PM
Composite Foreign Key bijgupt SQL Server 2005 6 May 4th, 2007 08:46 AM
FOREIGN KEY and PRIMARY KEY Constraints junemo Oracle 10 June 15th, 2004 01:00 AM
Foreign Key Problem re_anu SQL Server 2000 1 September 26th, 2003 10:58 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.