Creating two form templetes in one

[Slo]

I am trying to query a database using database form templete. I have
accomplished this but then I need to use a blank templete on the same form to
use text boxes and other type boxes. Can two form templetes be used on the
same form without using custom code? Or do you have us use a blank form and
use a botton to query the database and they use the rest of the form for text
boxes.

 

[Clay Fox]

I believe you are just need to explore views. Each form can have multiple
views and you can move between them with buttons.

There is no reason you cannot have database fields and other fields together
in one view but it is good practice to segment your form into views.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[Slo]

Clay

What I am trying to do is have a customer number entered by the user, then
select the 'search' button. This will read a SQL database and load customer
information on the form. I did this by using the forms templete "database
conneciton'. This worked great. Then the form needs additional text,
drop-down, etc. fields. When ever I drop a text field to the form, the
database field 'selection' box appears and wants me to select a database
field. At this point in the form I am done with database field. It's like
the form templete is only allowing database fields. Does this make sense
??????? Obviously I have done something wrong.

 

[Clay Fox]

What you need to do is add the fields you need to the Main Data Source.

Right Click and Add.

Typically I always add the fields first and then drag them to the view
instead of dragging text boxes and then assigning them.

You may also want to look at the Database Accelerator Web Servies Suite.
If you continue developing InfoPath Solutions with backend databases you
will run into the limitations that a database form has, one table, only one
submit, limitations on field size, etc.
With Database Accelerator you can use Webservices and have all the
flexibility you need plus a lot of additional features.

Free Download http://www.qdabra.com
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[Slo]

Clay

Thanks for the help. It's obvoius I have created something incorrectly
because no matter what I attempt to add to the "database" templete, it wants
me to select a field from my datasource. For some reason a database templete
will not mix with simple text entry fields. I even tried to create a new
view with no avail. Thanks

 

[Clay Fox]

Sorry for the delay - I was out for a few days.

You need to add fields in the datasource pane on the right. not in the view.

In the tree view where you can expand and contract you can right click on
the root node and add fields. Which then you can assign controls to in the
view.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[Slo]

Clay

Thanks for the direction. I will see if I can add fields to the datasource
in the next couple days. I really appreciate your input.

 

[Slo]

Clay

It worked. I was able to add a text field to the datasource area. Then I
moved the field to the templete. Thanks for your patience !!!!

Thank you for your time and efforts.

 

[Slo]

Clay

I need to add a drop down box field. This is not one of the field choices
with the right click option. Is this field not an option? or is there a
different technique to gettting the drop down box to work?

 

[Slo]

Clay

Ignore my last posting. I figured it out. Were learning, Thanks.