InfoPath Dev

hi all,

i already have the feeling that i am pushing the limits of InfoPath way beyond it's designers imagination but unfortunately i really have to do it ...

i have the followings:

1. one external data source let's say : item 1, item 2, item 3 (and many more items if you want)

2. one repeating table with a dropdownlist in it and that dropdownlist is bound to my external data source.

the problem: every time i insert a new item in the repeating table i want the dropdownlist to contain the values that were not previously selected. i still did not figure it out how should i treat a change of the first item after the second one was selected ....

a short example (later edit: what is bellow should have been 2 dropdownlists): 

Hi,

  Please verify the "Add a uniqueness filter to the Year drop-down list:" condition in the following link.

http://www.infopathdev.com/blogs/greg/archive/2005/07/14/Create-a-Repeating-Cascading-List-from-a-Flat-Data-Source.aspx

 Hi Anuma,

 In that post is described the functionality of the "Show only entries with unique display name" check box which unfortunately is not helping me. Remaining at that example if I select a Year when I choose Insert item the next repeating row must not contain a dropdownlist with the previous Year values.

 From what I see I really need to access and iterate through each item of the dropdrownlist and also to access the external datasource items. I am thinking of creating an array with datasource valid items and to bind them manually to the dropdownlist. I am somehow confused about how this should really look at the end cause I see no programmable solution :(