Capture date modified if reference field changes

Question

Hi Everyone ,  I am currently in a project where i need to give data changes which has happened from past 1 week  .  Initially it looked easy as we have date modified in each and every table. But the catch is in almost every table there are reference field ( table to table relationship) . If those column changes  then the reference table date modified does not change. For Eg . If in Table A  , table B is being referenced the changes happens in table B get reflected to table A but date modified does not change. Any advise please

QuickBaseCoachD · Answer

If lu want to have a parent know that maximum Date Modified of it�s children, then make a summary field of the Maximum Date Modified of its children.

Then have a field that calculates the

Max([Date Modified Of Children], [Date Modified])

You can use this same technique with lookup fields as well when you are going �down� instead of Iup.

Sign up

Login to the community