Hello Everyone,
I thought i had posted this already but i couldn't find the post, so please excuse if this is duplicate data.
I have a combox on my form in the master section of a master/detail. I am hosting my form in visual studio 2005 using the formControl and am using infopath 2007. The combo box has a fairly long list of items in it and so i created a button in my windows form that would update the datasource built on a filter value. This works and is all fine and good. My problem is that if the user selects a value fromt he combo box and then creates a new record and uses the filter to narrow down the items in the combo box any other rows that were not created directly from the filter now show their ID instead of their string name and this is because the combo box is set up to display the text and store the value of the secondary datasource. I don't want this to happen, is there any way i can prevent the ID from showing up when i use the filter.. i want it to continue displaying the name and i need the combo box to be set up as it is with display name and value.
Any information would be great!
thanks,