My 2 tables examples:
Code:PERSON ---------------------- PERSON_ID PK Autonumber PERSON_NAME Text ... ITEMS_HELD FK Multivalue-LookupI need to get all the ITEMS_HELD by a particular person.Code:ITEMS ---------------------- ITEM_ID PK Autonumber ITEM_NAME Text ...
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.
This isn't for an assignment or anything. It's for a personal project I'm working on for a video game. See Home SiteCode: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"));