Re: master detail in designer dd question

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.

1. Create your table usages so that the master is above the two details.
2. Be sure the foreign key columns to the master are present in both of the detailed usages.
3. 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 CDT