InfoPath Dev

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?

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

 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

 

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

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