Re: Designer 2000 - Foreign Key

You can in fact create Primary Keys, Foreign Keys and Uniques keys on Views *within* Designer/2000.

You must be sure to set the "Enforcement/validation" to be at the ***CLIENT*** side, **NOT** "Both" or "Server". (You can also set the enforcement to none).

This will cause the Forms generators to produce client side enforcement/validation code for the constraints.

Note that constraints can involve both tables and views.

Andres Estrada <xenco_at_xenco.com> wrote:

>I have a table and I am trying to create a Foreign Key relationship to a
>VIEW. It's possible ?
>What Do I Need to do ?
>
>Thanks
>
>Andres Estrada
>XENCO
>Please send a e-mail
>AndresE_at_xenco.com
>Andresestrada_at_hotmail.com
>xenco_at_xenco.com

-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 Jun 09 1997 - 00:00:00 CEST