InfoPath Dev

Thanks for sharing this informaiton.

what control should the Project manager be? I am using it as a text box? Should it be a calculated feild?    

Test it in Preview mode to populate drop down lists.  If you already have and still don't see anything in the lists, then you probably didn't set up your filter correctly....take another look~

I understand what Hilary is saying if it's true that you have an "original" list to read from instead.  I don't know if this will work but can you add a function to parse the string value to strip out the prefix?  e.g. substring(@CorrectValue1, 4, 4)?? Not sure but you could play around with it.  

[quote user="leoffneym"] Is the extra information unique to the Project Name Ex: Project Name = Phoenix, Project Manager = Bob, EndDate = 12/12/11, Status = In Progress [/quote] This is the way the day is , a unique project name and number. I followed the instructions, and in the preview it stills shows that txtbox feild ...

Happy to hear it worked. The filter is a great tool. Filter is kinda like an if/then statement. It is also so much more.

OMG - This worked perfectly except for one thing: from the left drop down, find the FileName from the data source that contains the information needed, will not be the Main data source leave the center on as is equal to from the right drop down find the FileName in the Main data source I switched these around so that the left was ...

I haven't tried this yet but this article may be a potential solution to this problem: http://sharepointgeorge.com/2010/item-level-permissions-infopath-forms-sharepoint-designer-workflows/ I love having forum conversations with myself. :(

Update: I solved the problem.  Found most of my answer  thanks to this post: http://social.msdn.microsoft.com/Forums/en-US/sharepointinfopath/thread/c04ef25e-d0f1-4d6d-bb39-f103ffe1fee5 Solution: find all references to offending (missing) data object in the .xsn "package"  files that are created when you design your ...

You will learn more with experience. Try this and see if works for you: In the FileName Properties  add a new rule click add (name the rule as you wish) click add action from the drop down, select Set a fields value in the Field text box, select the find a field button, find the Client ID in the Main Data source in the Value text box, ...