Re: Kindly Help me

From: Shiu W. Chee <shiuc_at_home.com>
Date: Tue, 15 Dec 1998 03:43:22 GMT
Message-ID: <uVkd2.276$EV6.102_at_news.rdc1.tn.home.com>


Did you try to create foreign key constraints on the parent child tables. This can be done easily in Designer/2000.

Steven wrote in message <3676AD05.3AD818B1_at_pacific.net.sg>...
>hi,
>
> l have two exiting Parent and Child tables.
>
> May l know what's the actual command for me to use at SQL
>worksheet,
> in order to make them "on cascade delete" ?
>
> Purpose: when l deleted the parent table's record, the child
>table's record
> will be deleted as well.
>
>
>
>--
>With regards
>Steven
>
>Steven Koh, Internet Software Engineer,
>Mediaworks, Pacific Internet Pte. Ltd.,
>77 Science Park Drive, 04-09/12
>Cintech III, Singapore Science Park,
>Singapore 118256.
>
>Tel: (65) 7711305;
>Fax: (65) 8728523
>www.mediaworks.com.sg, www.pacific.net.sg
>
>
Received on Tue Dec 15 1998 - 04:43:22 CET

Original text of this message