karlis
Member
I recently converted a rather large db from Access to SQL and am using Fabrik to make my life easier.
My question is not covered in the wiki about repeated elements/groups.
The questions is about three tables.
The first is "Retreats" the second is "Participants/duties" and the third is "Person".
Retreats<-one---many->Participants/duties<-many---one->Person(as a menu in Participants).
I have a form for Retreats with a group Participants/duties, where I can choose who is attending and what they will be doing. Simple enough.
But when I add a new Participant, I have to also specify which retreat, even though Partiipants/duties is a group of Retreats.
Any ideas?
My question is not covered in the wiki about repeated elements/groups.
The questions is about three tables.
The first is "Retreats" the second is "Participants/duties" and the third is "Person".
Retreats<-one---many->Participants/duties<-many---one->Person(as a menu in Participants).
I have a form for Retreats with a group Participants/duties, where I can choose who is attending and what they will be doing. Simple enough.
But when I add a new Participant, I have to also specify which retreat, even though Partiipants/duties is a group of Retreats.
Any ideas?