https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/122318.aspxWed, 29 Jan 2020 16:49:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122318Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122318.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122318Great job figuring it out :)https://www.infopathdev.com:443/forums/thread/122315.aspxWed, 29 Jan 2020 01:56:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122315specoop0https://www.infopathdev.com:443/forums/thread/122315.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122315OMG, I just realized my error...it's sitting right in front of me. On the filter, it says "Value." When I changed it to "All occurrences of Value" it worked!!!! Thank you! really appreciate the support. Infopath is pretty cool...https://www.infopathdev.com:443/forums/thread/122314.aspxWed, 29 Jan 2020 01:49:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122314specoop0https://www.infopathdev.com:443/forums/thread/122314.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122314See attached file! Thank you so very much.https://www.infopathdev.com:443/forums/thread/122312.aspxWed, 29 Jan 2020 00:34:56 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122312Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122312.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122312I think that you will need to query the Names list when the form loads, instead of when the selected locations change if you allow them to select multiple locations. I think you need to just use conditional formatting on the section that displays name to hide it if the location is not equal to any of the selected locations.... I'm going to guess that the Location in the Names list is actually the ID for the location, since it's a lookup. Any chance I can see a copy of your form? It would be easier for me to give you a hand.https://www.infopathdev.com:443/forums/thread/122307.aspxTue, 28 Jan 2020 21:50:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122307specoop0https://www.infopathdev.com:443/forums/thread/122307.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=122307See attached zip file for images! Hello! I’ve been working helping build an Infopath list, and it’s grown into something that’s beyond my skills - and I’m reaching out to see if I can get some support. My Situation: I have 3 lists: List 1 – Location (1 column, title) List 2 – Names (2 columns, name + a lookup to the location (can select multiple locations). List 3 – Infopath List What I want: When they pick a location in the infopath form, I want the names to automatically appear (e.g. when they pick location 2, individuals with that location are shown). What I’ve done so far: 1) I’ve added the data connections. 2) I added a Rule on the locations list to query the data connections List My coding skills are VERY basic and I don’t know xPath, so I tried building something with lots of hidden columns and workflows, but I couldn’t get name with multiple location lookups (e.g. Judy) to appear). I know Lookups are stored as ID’s, but not sure how to best make this work. If you have any guidance, that would be MUCH appreciated. Best, Spencer