[V4RB] ? about cascade deletion and many to many relationship

[Ruslan Zasukhin]

on 2/6/03 8:18 PM, Kevin Windham at kevo at gatorgraphics.com wrote:

> Say I have a link table  t12 with t1.ptr and t2.ptr so I have a many to
> many relation between t1 and t2.
> 
> Now when I delete a record  t1 I want the associated link records in
> t12 to be deleted, but I don't want the associated records in t2 to be
> deleted.
> 
> If I understand the Cascade option correctly, it will delete records in
> t2 also. 

NO! only in T12

You even do not have delete records from T2 automatically.

> Is that correct, and if so how would I go about handling this
> situation? If I am wrong, can someone tell me how to set up the
> deletion properly.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------