I'm working on a page to display the data from two sharepoint lists.
SharePoint List 1: ID, Name, Position, Project
SharePoint List 2: ReferenceID, Worklocation
** ReferenceID = ID in SharePoint List 1
I would like to display the data in a table when the Project = A, there might have few items in the SharePoint 1
Project Name: Project A
ID, Name, Position, Work Location
2, Name2, Position2, Work Location2
3 Name 3 Positoin3, Worklocation3
I can't figure out how to query data to display the info in sharepoint 1 & sharepoint list 2 in jquery. If anyone can help that would be great.