"I think Mark might have been using his iPad while he was skiing." I figured something like that :-)))
The app is for planning activities with customer care specialists.
The activities table is related to the specialists table (each specialist can have many activities)
The activities is also related to an attendees table for enabling multiple specialists selection for group activities. (each activity can have many attendees)
This attendees table is also related to the specialists table. (each specialist can be many attendees).
I would like to be able to show in a report the last activity that was conducted with a specialist, and the date of this last activity (Maximum start date).
To begin try to accomplish this, I edited the relationship as such:
But I'm not sure if this is the right start; where to put the formula, and what is a formula of 1, are unclear to me.
Thanks again for all your help!