Rick,
>I have a maintenance form that maintains Table A. I would like to log the before and after image of each changed column in Table A to Table B. I have placed the logic to do this into Table A’s HookPreSave method. The problem I am having is that I cannot find a way to get Table B to participate in Table A’s Transaction. If there is an error in the validation of Table A changes are not applied to Table A however these changes are being logged to Table B even though Table A has not passed the validation process. I would like to know how to get Table B to update only if Table A successfully updates. Also, if either table fails to successfully update then I want them both to rollback. They must remain in sync. AutoUseTransactions is set to true on Table A’s BO.
I just saw a post from Kevin about how to do this on this board a couple of weeks back.. You might try a search on Transactions to find it. I assume you read the "Working with Transactions" section under Data Access with MM .NET in the Dev Guide. If business objects are related they will roll in the transactions together automatically. However you could manually call the transactionBegin, Commit, and Rollback of each as needed.
Tim
Timothy Bryan