I have two Lists in SharePoint 2007
Actions list has a Lookup column called Client which takes its values from Clients List. I want to display all those clients which are NOT present in Actions list. My approach is to first get all the clients from Clients list and then iteratively check them whether they are present in Actions list or not. This approach is not scalable and I was wondering if there is any better approach for it?
I am using GetListItems method of Lists.asmx web service as I do not have permission to deploy custom web part assembly on server.