Solved
Tracking Most Recent Data
Good day everyone! This is likely convoluted. I haven't been able to figure a way to actually do this and I feel like I'm missing something obvious. I have a couple of tables that will hold s...
Hi Mickey,
I think you might have more success if you use an Assets table like this:
Make Assets the Parent of Tickets.
Then you can use summary fields in the relationship, in this case maximum Record ID of the child tickets, along with a combined text summary of the issue description from the ticket that matches that maximum record ID.
NOTE: For this to work, you will also need to pass the maximum record ID back down to the tickets table as a lookup in the relationship. This allows you to create the filtering on the combined text summary field. Record ID = Maximum Record ID. Think of this as the Ticket Record ID making a "round-trip" from the Tickets table to its parent and back.
