Hello all together!
I have a problem and can't find any solution (searched nearly 2 days in this forum). I create an InfoPath2003 form based on a Access2003-database. I also get a query- and a data-section with corresponding fields. The data-section is as a repeating section for dispaying several datasets from database. Now i have to populate an dropdown field which is not a part of the data-fields, because i only get an string like "1;2;5;7" from the database. This numbers are ID's and in a seperate table in the database are names to each ID. Because of more then one ID in the string the dropdown-field is in a repeating table, which is bound to an seperate group under "myFields" in the datasource. Following i show the structur of my database for more understanding i hope.
-tblMain
---field1
---field2
---IDs
-tblID_Name
---ID
---Name
After some days of work i get a solution, which returns the names for each dataset appanding from the IDs-list (return from tblMain for each dataset). I also can add some rows to the repeating table and set the names to the dropdown-field BUT only for all datasets the same. If i change the value in one dropdown-field then the dropdown-field in ALL datasets are changed. I think it's because the repeating table isn't a part of the repeating section. (i get an information from InfoPath that this control coudn't repeat at this point - but how can i change this?)
I hope somebody could understand my problem and can help me. PLEASE!
Andrea