I have table1 inner joined with table2. And table2 inner joined with another 3 tables.
I want to enable change tracking on table1 and table2 only. And Only if a certain field is changed on table2.
so this certain field gets incremented whenever an update happens on table1 or table2. So my change tracking should only work if this certain field in table2 changed. How can i do that? is it doable via custom default query? and if yes how?