We have used Creator to create a kind of CRM that links contacts (customers, in our case teachers) with interactions (in our case, usually some kind of field trip or outreach program).
To facilitate this, we have a bidirectional relationship between 'Teachers in attendance' on the Interactions form, and 'Interactions' on the Contact form. It works pretty well, as this allows us to view all of the times a given teacher has worked with us over the years. However, as each related field from the interaction form (such as the schools they represented, the grade level of students they brought, etc.) appears on the Contacts view as a list of all of the values entered for every interaction they've had with us, the Contacts view is very cluttered. We have a lot of returning teachers, and many of them change schools or grade levels, so it gets messy.
What I'd like to do is just pull the ID for the MOST RECENT interaction and pull the school, age level and such from that form to display in the Contacts view. However, I'm having trouble trying to figure out how to take the list generated by the Interactions field on the Contacts form and select just the interaction with the most recent date.
I imagine this isn't hard to do, but I'm struggling to figure it out. Can anyone help?