InfoPath Dev

 Thank you for the tips, Patrick! This may be a dumb question, but if I created the view, then how would I make sure that my external list has the freshest data?  Would the view refresh periodically, or would I need to schedule that? Thanks again, William

That was the solution, Potemkine.  Thanks! 

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

 Hi Everyone,  I am working on a query form with several pages/views. Every page has got 960 formulas using expression box. One of the formulas is as follows:   sum(dfs:dataFields/d:top/d:transplants_NDD/@LungSingleChild[../../@PrgYear = ...

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?

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 ...

Hi, Hope you have got the solution from previous post. But I would prefer following simple solution which is a kind of same thing:  Access AutoNumber field Format to "0000000000". It keeps the length of the field 10 digits long from right keeping the leading zeros.  You do not need to create an InfoPath form field/node ...

Hi Jimmy, Thanks a lot for your help! Problem solved! :-) Regards, Niels

Yep - essentially I rolled back to the way I was doing it.   I was trying to do so in order to make things 'clearner' ...   Thanks for the response. [quote user="Patrick Halstead"] As far as I know that is not supported. I recommend putting the lookup values into a separate list and creating a data ...

Hi Patrick, Is there a sample installer script I can see? Thanks.