I have three tables:
Companies > Locations > Contacts
A summary field in the Companies table lists the # of Contacts for a Company, but when it's clicked on, it's takes the user to a list of the Locations, which then has another summary field users would need click on to see the list of Contacts at each Company, but users instead want to see a list of all Contacts at Company when they click on the summary field from the Companies table.
Is this possible? If so, how?