My 2 tables examples:
Code:
PERSON
----------------------
PERSON_ID PK Autonumber
PERSON_NAME Text
...
ITEMS_HELD FK  Multivalue-Lookup
Code:
ITEMS
----------------------
ITEM_ID PK Autonumber
ITEM_NAME Text
...
I need to get all the ITEMS_HELD by a particular person.
Example:
PERSON_NAME - "Devin"

Devin holds "Cup, Crayon, Sandwhich"

Does this make sense?

I think the follow select statement (found it online) is along the lines of what I need but I cannot figure out how to format it correctly. The data gets jumbled in my head.
Code:
SELECT Issues.Title, Issues.AssignedTo 
FROM [Contacts Extended] INNER JOIN Issues ON 
[Contacts Extended].ID = Issues.AssignedTo.Value 
WHERE ((([Contacts Extended].[Contact Name])="Kelly Rollin"));
This isn't for an assignment or anything. It's for a personal project I'm working on for a video game. See Home Site