Hi,
I'm new to fabrik. I've got my one-to-many relations working fine and my many-to-many ones, but am having trouble with many-to-one relationships.
My test data consists of two tableserformances and Shows
A performance contains an ID, a Date and is linked to a show with a Show_ID. The show contains an ID and a Show_Name.
e.g
Performances:
ID DATE SHOW_ID
1 11/06/15 1
2 12/06/15 1
3 13/06/15 2
Shows:
ID SHOW_NAME
1 Hairspray
2 Matilda
I link the performance to the show by joining the Performances.SHOW_ID to the Shows.ID in the Performance's list->data->joins.
So far so good. I now get:
Performances:
ID DATE SHOW_NAME
1 11/06/15 Hairspray
2 12/06/15 Hairspray
3 13/06/15 Matilda
When adding a new performance, I don't want to add a new show, I just want to select from the shows already there, so I set the Performances-Shows group's Layout->Show_Group option to "no".
Now when I try to add a new performance, it looks good: I just get a field to enter the date and one to enter the show ID. But when I click save, though the performance gets added with correct info, the show I selected has all its data wiped!
e.g. if I try to add to a new performance on 14/06/15 to the show with the SHOW_ID of 2, I get the following result:
Performances
ID DATE SHOW_NAME
1 11/06/15 Hairspray
2 12/06/15 Hairspray
3 13/06/15
4 14/06/15
Sorry for the essay, but can anyone see what I'm missing? This is driving me nuts!
I'm new to fabrik. I've got my one-to-many relations working fine and my many-to-many ones, but am having trouble with many-to-one relationships.
My test data consists of two tableserformances and Shows
A performance contains an ID, a Date and is linked to a show with a Show_ID. The show contains an ID and a Show_Name.
e.g
Performances:
ID DATE SHOW_ID
1 11/06/15 1
2 12/06/15 1
3 13/06/15 2
Shows:
ID SHOW_NAME
1 Hairspray
2 Matilda
I link the performance to the show by joining the Performances.SHOW_ID to the Shows.ID in the Performance's list->data->joins.
So far so good. I now get:
Performances:
ID DATE SHOW_NAME
1 11/06/15 Hairspray
2 12/06/15 Hairspray
3 13/06/15 Matilda
When adding a new performance, I don't want to add a new show, I just want to select from the shows already there, so I set the Performances-Shows group's Layout->Show_Group option to "no".
Now when I try to add a new performance, it looks good: I just get a field to enter the date and one to enter the show ID. But when I click save, though the performance gets added with correct info, the show I selected has all its data wiped!
e.g. if I try to add to a new performance on 14/06/15 to the show with the SHOW_ID of 2, I get the following result:
Performances
ID DATE SHOW_NAME
1 11/06/15 Hairspray
2 12/06/15 Hairspray
3 13/06/15
4 14/06/15
Sorry for the essay, but can anyone see what I'm missing? This is driving me nuts!