InfoPath Dev

Hello everyone,

I have a sharepoint (SharePoint list 1) list that has 2 columns: column A which has values of 1 - 99 and column B which has random names. I have another sharepoint list that uses the values from sharepoint list 1, which I pull into a form.

Here is my question, I want to know if it is possible to filter the drop down list values (pulled from sharepoint list 1) in the sharepoint list 2 form based on the stored values in sharepoint list 2. Lets say I'm filling out the form in sharepoint list 2 and I fill in some random fields and I get to the drop down selector that pulls the values from sharepoint list 1, and I select one of those fields then submit the form to post to sharepoint list 2.  Next, I am creating another entry using sharepoint list 2 form and when I get to the drop down list, I want it to display the remaining values, minus the one(s) that I have already used from previous submissions. 

 

 

Here's a simplified sample of the filter you need on the dropdown - you'll need to have a data connection to list 2 in the form (so you know what all has been used) then on your dropdown you can add a simple field from list 1 = field from list 2 filter and wrap it in a not(). Save the attached file locally, right click and select design, then preview.

 wow I cannot believe it was so simple. I just used expression when I applied the filter on the value that I wanted, and viola!! it worked. Thanks