 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / July 2007Creating a Form before a database
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 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.  SignatureKalyan G Reddy - INFOPATH MVP 2007 http://www.ggktech.com > 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, [quoted text clipped - 9 lines] > > Thank you 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. > Hello > [quoted text clipped - 15 lines] > > > > Thank you 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. SignatureKalyan G Reddy - INFOPATH MVP 2007 http://www.ggktech.com > I was assuming the schema was the structure of the data base. What is the > difference, where do I create a schema? [quoted text clipped - 21 lines] > > > > > > Thank you 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. SignatureDavid Dean Sr. Member Technical Staff Insource Technology Corp. > I was assuming the schema was the structure of the data base. What is the > difference, where do I create a schema? [quoted text clipped - 21 lines] > > > > > > Thank you 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. SignatureThanks Clay Fox Qdabra Software http://www.qdabra.com InfoPathDev.Com The Largest InfoPath Forum in the World http://www.infopathdev.com > 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, [quoted text clipped - 9 lines] > > Thank you
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.