inactivate constituent records

This may be too crude to use since I'm not sure what other actions might be triggered when you inactivate a constituent from witin the client, but from the database I might try something like

update t_customer

set inactive = 1

where customer_no in (

select customer_no

from t_list_contents

where list_no = ###

)

Or would that be too much like using a stone axe to cut down a tree?

This may be too crude to use since I'm not sure what other actions might be triggered when you inactivate a constituent from witin the client, but from the database I might try something like

update t_customer

set inactive = 1

where customer_no in (

select customer_no

from t_list_contents

where list_no = ###

)

Or would that be too much like using a stone axe to cut down a tree?

Levi, you are close.  The inactive_reason would need to be set for the inactive constituents as well. 

Best,

Anna

Anna E. Wessely

Manager Asia Pacific/Senior Application Specialist

Tessitura Network, Inc

+1 888 643 5778 x 308

awessely@tessituranetwork.com

www.tessituranetwork.com