Combo boxes and data sources .. it's complicated!!

[esebastian]

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 combo boxx 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 from the 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,