repeat within a repeat?

[brian]

Hello,

I have two tables, Table_1 and table_2, on my form, table two is a repeat group,

Group1{
id-
date
taskname
}
group2_repeatable{
id
parent_id
user
completed - yes/no
}

With the above setup I can add a task for multiple users, However i have been trying, unsuccessfully, to add the ability for adding multiple tasks per user. I have created a new group[group0], and moved the PK to the new group and then i have made group 1 repeatable. However this only adds a completed-yes/no per parent id and i would need the ability to update a task as completed per user per task,


Group0{
id-PK
date
}
Group1_repeatable{
id-
parent_id
date
taskname
}
group2_repeatable{
id
parent_id
user
completed - yes/no
}



The best way i can describe my requirement is that for each repeated row, in group 1 i would like corresponding repeat rows in group2.

Can someone point me in the right direction? If anyone can shed some light on this, i have done my best to explain it as best i can, I would be willing to pay to get this functionality as its been bothering me for two weeks now.

Thank you for your help!

 

[cheesegrits]

Sounds like you need a many-to-many relationship.

Users
id (PK)
userid

Tasks
id (PK)
taskname

UsersTasks
id (PK)
users_id (join to Users.id)
tasks_id (join to Tasks.id)
completed

Then in the Users list, create a join from Users.id to UsersTasks.users_id, and make it repeated.

-- hugh