General

Re: Drop down-list box from SharePoint list with non-unique list entries (problem)

Potemkine — Mon, 07 Mar 2011 18:38:49 GMT

You're welcome :)

Re: Drop down-list box from SharePoint list with non-unique list entries (problem)

shniggens — Mon, 07 Mar 2011 17:11:41 GMT

That was the solution, Potemkine. Thanks!

Re: Drop down-list box from SharePoint list with non-unique list entries (problem)

Potemkine — Mon, 07 Mar 2011 16:15:26 GMT

Hi, you can use the "ID" instead the "Title", you set your drop down vale as the "ID" and the display name as "Title".

Re: Drop down-list box from SharePoint list with non-unique list entries (problem)

shniggens — Mon, 07 Mar 2011 16:00:03 GMT

So I took the filter off, and now the form shows 3 "Jobs" in the list, as it should. However, all of them that it picks are the first one in the list (from last year). Do I need to set the SharePoint query field for ID or something?

Re: Drop down-list box from SharePoint list with non-unique list entries (problem)

shniggens — Mon, 07 Mar 2011 15:51:27 GMT

The form is too big to attach.

This is driving me crazy. So, I have 3 jobs in my list named "Job". 2 are this year, and the other one is from last year. Only two show up in my drop-down, so it would seem that the filter is working correctly (filtering out the last year). However, the data that gets pulled for both of the jobs in the list is from last year. Also, when I pull down the list, I pick the first "Job". When I pull down the list to pick the other one, the second one is already highlighted.

Does this make sense?

Re: Drop down-list box from SharePoint list with non-unique list entries (problem)

Patrick Halstead — Mon, 07 Mar 2011 10:25:03 GMT

You should be able to filter out to only show the one for this year. You can use either in-form filtering (slow) or server-side filtering via FilterOwssvr (use qRules to dynamically parameterize). I'm guessing the preview thing is just because the default data set is 2 - probably you can ignore that.

Attach your form and we'll take a look.

Drop down-list box from SharePoint list with non-unique list entries (problem)

shniggens — Sat, 05 Mar 2011 20:02:16 GMT

I have a drop-down list box in a form that pulls from a list of jobs. Each of these jobs has unique information, such as job number, dates, etc. These jobs repeat every year, therefore they keep the same name year-to-year. I never had a problem pulling data from this list when I had only one entry for each job. But now that I am adding jobs for this year, I am having some complications with multiple list entries of the same name. The job name populates the other fields in my form (job number, date, etc.)

Here's what happens.

I have two jobs in the list with identical names (the name is what the drop down list shows). I can see both of those jobs in the list when I drop it down, however both of the names pull in the same data. To further complicate matters, I have a filter set on the drop-down to only show items after the first of the year. After I have added multiple jobs of the same name, it picks the first one in the list, and which is last year. So the filter doesn't work, either.

Another wierd thing, when I preview the form in Infopath, it shows multiple instances of the same job, whether multiple instances of the job exist in the list or not.

Any ideas?