Re: master detail in designer dd question
Date: 1997/05/26
Message-ID: <3389c730.1208999_at_nntp.ix.netcom.com>#1/1
Duane Raymond <duaner_at_ai.aiesec.org> wrote:
>Hello
>
>Is it possible to have more than one detail tables in the data
>diagrammer?
>
>eg:
> (master> (detail)
> individual ---------> topic
> ---------->adress
>
>because I can't find how to do that.
>
>Please send also reply to nicoj_at_ai.aiesec.org
>
>Thanks.
>
Yes, its possible and very easy.
- Create your table usages so that the master is above the two details.
- Be sure the foreign key columns to the master are present in both of the detailed usages.
- Click on the links button and draw a link from each of the detail usages to the master usage.
You must have foreign key constraints defined from the detail tables to the
master table.
-JJ
Jeffrey Jacobs & Associates
Oracle Designer/2000 Consulting & Training
951-2 Old Country Road, Suite 119, Belmont, CA 94002
Voice: 415-571-7092, FAX: 800-665-1379 CompuServe: 76702,456
Internet: jmjacobs_at_ix.netcom.com
Don't miss ODTUG's Spring Conference, June 3-6, San Diego! Visit http://www.odtug.com or call 910-452-7444 for info! Received on Mon May 26 1997 - 00:00:00 CEST