InfoPath Dev

Hi I have a multiple list box which receives it's data from a SQL table. I have another multiple list box which receives fields from another SQL table filtered on whatever was selected in the first multiple list box. I want the second multiple list box not to be choices, but to have all the entries selected (can i use anything other than a ...

Hi Hilary I have had a chance to solve the problem. And it works! I don't know where to begin...! An on load rule.. to set a field value within form (main data connection). this field value was based on the filtered values of Units and Unit Types (these were secondary added data connections, with the correct columns and filters (the ...

Hi Hilary I have included the template file. Field 1 returns the correct value (1-10 from the Unit Types list). the other fields are me trying to store this result (so that i can filter the Unit Types list), but i only get the ID value from Units (1-221). I can seem to store the Unit Types number. My intention is to wrap each question ...

Hilary - first of all many thanks for your swift reply and advice. Brilliant! I will try out your suggestion this morning and let you know how it goes. If i post you a template, how do you get the interactions with the various lists? This may be an unnecessary explanation... however I'd like to get better at explaining and give at a ...

I have an InfoPath form (Requests) with various sections that need to be displayed or not depending on the item code that is selected. The 'Item Code' list has a look up to a list called 'Units' which has a look up to a 'Unit Type' list. The InfoPath form is based on another list called Requests i.e. it does not ...