Re: More elegant way to summarise records based on condition .
Gunsham,
Without knowing much more, I would solve this by creating a Changes or a Histories type table. You could then have an automation trigger off of one of these fields being modified, and push all four items to your other table. With a relationship in place as well, you'd see a running history of what changes were made and when they occurred.
If this doesn't solve your need, please provide further details and I'll be happy to help further.
Eric
------------------------------
Eric Mohlman
------------------------------
Without knowing much more, I would solve this by creating a Changes or a Histories type table. You could then have an automation trigger off of one of these fields being modified, and push all four items to your other table. With a relationship in place as well, you'd see a running history of what changes were made and when they occurred.
If this doesn't solve your need, please provide further details and I'll be happy to help further.
Eric
------------------------------
Eric Mohlman
------------------------------
