All our contracts store an activity when an email is sent to a client. Using this tutorial (http://help.skuid.com/m/models-conditions-filters/l/102520-include-child-relationships) I was able to create a Skuid page as required. My issue now is that non Salesforce Admin users receive the following error message:
"There is an implementation restriction on ActivityHistories. When you query this relationship, security evaluation is implemented for users who don't have administrator permissions, and only a single parent record may be evaluated.
An unexpected error has occurred. Your solution provider has been notified. (skuid)"
I found an explanation on the forum which makes sense:
"This is actually a fairly common error message,
and you'll encounter it in weird places on various Standard objects. It only
ever happens for non-Admin users, because non-Admin users' access to records is
governed by the Salesforce Security Model, whereas Admins have the "View
All Data" permission, which means that Salesforce ignores the Security
Model completely for them when choosing which records to let Admins access. So
for Salesforce's purposes, it's a lot more "expensive" to try to
determine which records a non-Admin user should have access to, because
Salesforce has to evaluate the whole Sharing Model for a given object when a
non-Admin user runs a query on that object. Therefore Salesforce puts in these
"Implementation Restrictions" that limit how many records of these
Standard Objects that non-Admin users can request in a particular transaction.
This makes sense for standard Objects like Task and Event for which there are
often millions of records in customers' orgs, because Salesforce's Query
Optimizers have to do a lot more work to try to search through these millions
of records trying to find ones that a non-Admin user has access to."