How to work Delete Option in Cascade of Joins

[Oscar]

Hi Everyone.

I've created one table called "c_activity_ext". This one have a relationship 1:1 with Activity Table. Saleslogix automatically created this relationship when the join is Left Outer in the parent table (Activity). Also this join have set Delete in Cascade Option and Always in Visible Option. 

Why when i completed a activity, the SalesLogix (7.2.2) just delete record in Activity Table and not delete associated record in c_activity_ext table?

I've already create c_activity_ext twice (delete and then back create this).

Pls, help me!!! 

[RJLedger · Accepted solution]

Oscar,

   When you customize Activity you should be changing the core Activity (and History) table - not adding a 1:1 table. Make sure you add the same field name/type to both tables and all works fine in SalesLogix.

Oh yes.. this is the incorrect forum for these type of posts - you should be posting to the:

   Sage SalesLogix Product Forum: Sage SalesLogix Product Discussions.

Could a moderator move this thread to the correct forum please?  - Thanks for the move!

Message Edited by RJLedger on 06-16-2009 01:29 PM

[Oscar]

Thanks RJLedger!

Sorry to put this message in incorrect forum.