Creating a Form before a database

L

lndavis

If I create a form and it creates an XML structure, do I then have access to
that underlying structure if I need to make changes to the form, add fields,
or data in a field?

Are there advantages to creating the structure or DB before the form.

If I create the DB before the form and base the form on the data base, if I
add tables or data to the DB, can this update the form?

Can you connect forms (data from one form populates part of another) and to
do this does that DB need to exist first?

Thank you
 
K

Kalyan G Reddy MVP (GGK Tech)

Hello

Its better to Build the Infopath form by creating the schema first.
You find lots of challenges if you build the form based on Db and they
modify the schema.
 
L

lndavis

I was assuming the schema was the structure of the data base. What is the
difference, where do I create a schema?

I have to create the database and form unless the form will build the
database or vice versa.
 
K

Kalyan G Reddy MVP (GGK Tech)

Hello

You start designing the Form by adding fields in the datsource. Infopath
will build its own Schema. Else if you are well versed with Xml, Schema, You
can write your structure of the form. Then you create the DB and connect this
to the Infopath form.

If you need assistance on how to connect Db to Infopath, Practise the
Infopath Labs available on the MSDN Site.
 
C

Clay Fox

I typically plan both concurrently before I start. I find it easier to layout
the database first, that way I can keep the form cleaner and if you connect
it directly then the schmema is pulled across directly.

You should also check out the Database Accelerator download.
http://www.qdabra.com it may help you out as well.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

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

David Dean

Your question makes the assumption that InfoPath is similar to other forms
tools that build database structures as you layout the form.

InfoPath forms are created as XML documents. The forms can be saved as XML
files and stored on a central repository like SharePoint, or you can submit
them to a web service or other data connection that parses and processes the
XML.
 
Top