InfoPath Dev

I guess I would test by using a form that has the checkbox for 'Automatically determine security level (recommended)' unchecked, and Domain selected instead. Could you try that?

I'm pretty sure that it's not possible to print from a button in a browser form. Could users just click the print button in the Ribbon?

Hi Shraddha, Unfortunately, with that many records, the data connection is bound to be slow. One alternative is to have users search. The data connection would return only results that match the search term and load those into the dropdown. Sadly, I don't believe that InfoPath allows this out of the box. You would need to create your own ...

Hi Mil, What you're looking for is called "cascading dropdowns". A Google search will yield a wealth of information, with different tutorials and methods. Here's one: http://blogs.msdn.com/b/infopath/archive/2004/03/24/create-dependent-drop-down-list-box-in-infopath-using-filters.aspx. Hope it helps!

Is this a database bound form? (i.e. is the schema locked?) If not, then it sounds like you're doing everything correctly, though there may be an issue with the filter (which depends on the form schema). Is there another column besides Supplier that you could use to filter? Maybe an ID field?  

Is this a SharePoint list (and a SharePoint list form) and not a Sharepoint Form Library? I just want to get an idea of whether we are dealing with a locked schema or not. Thanks.