Find out changed data

[Papote]

I have Table A and Table B which are similar. Table A is the main table and makes a copy to Table B. Some records in Table A are either added or deleted. Table B is later refreshed with the records in Table A to match it. How can I pragmatically know which were the records that were deleted and added off of table A before refreshing Table B.

[RuralGuy]

Have you looked at any Audit Trail code?