I have getting more and more familiarize with InfoPath 2010 but have had some challenges of late that I would like some advice on.

1) I use dropdown list boxes a lot to display AND data filters on text fields set from other lists but I can't figure out what I need to do to "reset" the dropdown  back to it's initial state and initial values (to start over)

2) When I do IP for lists that contains lookup columns I noticed the lookup and associated displayed columns are not available in IP so I always define a "text" col of the lookup and populate the field in IP and repeat for any of the associated columns of the list as well - is this the correct approach?

3) Similarly, when using choice columns I create a calculated column of the it and I then can access the calculated column in IP.  Is this the right way or is there a "correct" way as well?

4) Lastly a problem - I use LOTS of data connections and user query fields.  Lately it seems like the data connection queries are not returning the fields consistently.  For example a list contains cities and their state.  The first time I run it, it returns all of the cities for the particular state in the query field.  The next time and every time after I do  the same selection I would get a different set.  I know this must be something I did or didn't do stupidly.

Please help.

ray