InfoPath Dev

When the user is completing a form in InfoPath, they can use the File menu Send To: command just like in other office applications. Then they can specify whatever they want for the email parameters. This can be enabled and disabled in Form Options in design mode.

I think a lot would depend on what you want to show. For non-InfoPath clients to view IP forms you need Forms Services or a web server which can render the form in a browser.  You may want to check out the Database Accelerater since it includes a form viewer.Qdabra Database Accelerator Suite Version 2.1 - Developer With it you could make ...

You first need to figure out what SQL needs. I believe for a bit it should be a 1 or 0. Get submit working with that first. Then you set up your check boxes accordingly to use the correct values. Then when you set the fields for the check boxes from the secondary DC you perform a conversion if True set to 1 if False set to 0. I think that ...

A bit is a 0 or 1. You have tried a boolean field with both true or false or 1 or 0 as the default?  I cannot find anything specific on using bit fields with InfoPath but it may not work since it is a specialized data field. I think you would need to change it in SQL to a char or int instead of a bit. I would think a conversion to an int ...

I would change your checkboxes to text boxes and verify your values coming in from SQL.  Are they 0 and 1 or what?  Then makes sure you go into the check box properties and set the correct values for checked and unchecked. What is the column type in SQL?

Hey Ed. The Email submit is set and cannot be edited by the user. They can only send or cancel. Two options. 1. You can allow the Send To: command from the file menu but this just emails the current view. 2. Add the fields in your form itself, or create another view where they can update the fields before the email and then have the submit ...

You may want to convert from whole number to text and then switch your checkboxes to text boxes and verify what you are receiving from SQL. You can have them as text boxes in InfoPath and still use 0 or 1 or whatever the value is for your checkbox.  

The problem is the missmatch between your SQL fields and the field types your checkboxes are bound to.  You need to change from boolean type field to number in InfoPath, the fields the check boxes are bound to, and then configure the check boxes to be 0 or 1 to match your SQL data.  That will get rid of your validation issues.  ...

InfoPath form templates work with InfoPath clients or with a webbrowser client through leveraging InfoPath Form Services.  A Web Server hosts the form, with some reduced functionality, for non-InfoPath clients. You may also want to evaluate the Database Accelerator.  It has lots of features for adding functionality to forms via ...

Typically you would add a rule to the drop down with an action to set a field value.  You would select each checkbox and then set it to the value from your secondary connection with the filter custID = dropdown. You may want to check out the Database Accelerator, if you are working with SQL data.  It allows you to query and submit to ...