I have 2 tables:
- Contacts
- Helpers
The
Helper
field (which is linked to the Helper table) in Contacts
is a multi-valued field so more than one helper can be selected and displayed in a report.
Each Helper is linked to more than 1 Contact.
I'm trying to create a query selecting all contacts for one helper, and display all helpers for the resulting contacts. I think I am off-base with multi-valued fields, but cannot find another solution.
It is in Access 2010. Tables do not have multi-value fields. They are:
### Contacts
ContactID
Surname
Email
### Helper
HelperID
Name
Asked by Sue Snyder
(11 rep)
Jun 27, 2015, 01:17 AM
Last activity: Oct 31, 2018, 12:02 PM
Last activity: Oct 31, 2018, 12:02 PM