InfoPath Dev

Are you sure you have the control properly selected? Can you attach your XSN so we can take a look?

Hi Richaanth1, Sorry for the delay in responding. Unfortunately, using BCS on top of the database won't guarantee security. You could use a Web service such as Qdabra's DBXL (http://www.qdabra.com/en/products/DBXL.aspx) to easily set this up. There's a generic QueryDB Web service with various methods and lots of information under ...

Cool. Thanks for posting the workaround. Double submits are de riguer to get IDs in the form.

If you are selecting a repeating control, you should see it. There's a small chance you have InfoPath bug. Try closing all InfoPath instances down and reopen and select the repeater and check the dropdown. I've seen that bug one or two times.

Hi Sloveless and welcome, Have you refreshed the main data connection (needed if the DB schema changed)? In the early days of InfoPath (2003-2004), many people struggled with mapping XML data to SQL. To help those people we created a cost-effective Web service called DBXL which is an accelerator helping people quickly integrate their InfoPath ...

I would try repairing Office on the users machine. Sounds like a registry problem.

Can you attach your form (click Options and add it) so we can look at it?

I recommend clearing your InfoPath cache. Close down all running InfoPath processes. Then, click Start->Run and type in "InfoPath.exe /cache clearall" and hit enter.  After that has completed, close InfoPath and try to open your form again.

yes, you'll need to substring before the time zone. see modified xsn attached.

And, Being able to select the product once but select several sub products. So potential could end up with something like: Colours                             Red, ...