Databound Form and UI controls - Question for experts

[Fred]

Hello,

I have a complex data entry form that is directly bound to a SQL Db.
I would need to add some pure UI controls (checkbox to hide a section for
example), the problem is that as this is a databound form it seems that
Infopath is not allowing to add those ui controls as long as they are not in
the sql structure (I can add a button, but not a checkbox, textbox,
etc.....).

Question: is there a way to include a pure UI control (I mean not present in
the sql db) in a databound form?
Thanks

 

[S.Y.M. Wong-A-Ton]

Yes. The trick is to add the field to the Main data source of your form by
using the "Data Source" pane and not by dragging and dropping a control on
the form from the "Controls" pane. Once you've added the field to the Main
data source, you can drag it from the "Data Source" pane, drop it onto the
form, right-click on it, and change it to any control you want.

 

[Fred]

Thanks, in effect, it works. not intuitive but it works.
Fred