Working with controls.. - InfoPath Dev
in

InfoPath Dev

Having trouble finding a blog or post that answers your question? Check out our Custom Search Page

Working with controls..

Last post 11-22-2007 04:10 PM by pkeshtgani. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 11-21-2007 09:21 PM

    Working with controls..

    i have database in ms. sql server 2005. and then in infopath i have a form that send data to the SQL server and stores. everything is fine here. my question is... how do i have a repeating table in another repeating table which in total is another repeating... example below should explain There is a task (repeating table) and within that task there is a phase (repeating table) and also within phase there is activities (repeating table) 1. Task I. Phase i. activities. so how can i have this working to have the information send to SQL server and stored. at correct moments my repeating (click here to repeat table) for phase and activities are not working. but for the big picture (task) is working. also do i need to do anything special on SQL Server to have this working?
  • 11-22-2007 03:40 AM In reply to

    Re: Working with controls..

    Hi

    OK, so you need to have two extra tables in your database.  One to represent your phase and one to represent your activities.  Then link them in InfoPath from Task to Phase in a one-to-many relationship and from Phase to Activity in a one-to-many relationship.  This way each can appear inside the other.

    Cheers

    Adam Harding
    Wales
    UK
  • 11-22-2007 11:47 AM In reply to

    Re: Working with controls..

     so basically i would have 3 tables

    one to represent task

    one to represent phase

    and then one final one called activitities

    then i set up main connection on infopath and open up all the tables in there. and then i go there and i start creating the tables


     

  • 11-22-2007 12:11 PM In reply to

    Re: Working with controls..

    Yes

    that is correct.  But make their relationship such that the primary key in the tasks table is linked to a duaghter key in the phase table thus creating a one-to-many relationship, so for each task there can be multiple phases.  Then the primary key in the phase table is linked to a daughter key in the activities table to create the one-to-many between phases and activities.

    Once the data-connection is set up then add one table on your form for tasks, then inside it add another table for phases and inside that one another table for activities.  You can only setup repeating table inside others where the master table is in a one-to-many relationship in the daughter table.  Then it will work fine.

    Glad to be of help

    Adam Harding
    Wales
    UK
  • 11-22-2007 04:10 PM In reply to

    Re: Working with controls..

    hey i did all that but still got the same problem. when i put them all together the repeating table inside the main repeating table doesnt work. any suggestion
     

Page 1 of 1 (5 items)
Copyright © 2003-2012 Qdabra Software. All rights reserved.
View our Terms of Use.