Hi
I have been working on a address directory for our first aid association using fabrik. Unfortunately I don't get any further.
I have tree tables:
- osv_vereine (containing all the sections in the association)
- osv_adressenliste (containing all kinds of addresses of people in the sections)
- osv_kl_tl_ausbildung (skills of these people)
I made three list with these three tables, no problem.
osv_vereine to osv_adressenliste is a one to many relationship
osv_adressenliste to osv_kl_tl_ausbildung a 1:1
Also the forms work well. Displaying the information and editing existing people works fine.
Adding a new person though doesn't really work. Adding a person seems to work. If I try to edit the person I get a duplicate key error from the skills table.
What I would like to do is that I can add people, at the same time fill out the skills (different group in the form), as well as also add just the address and a couple of weeks later add the skills.
The skills group is normaly hidden. It is made visible with the right top most radio button setting KL/TL to ja.
It seems the me that there is a problem in the join of the tables.
I add a couple of pictures.
List = showing an overview of data from all three tables
Join = Join statements used
Detail = result (skills group at the very bottom "Technische Ausbildung")
Can you give me a hint?
Thanks
Roger
I have been working on a address directory for our first aid association using fabrik. Unfortunately I don't get any further.
I have tree tables:
- osv_vereine (containing all the sections in the association)
- osv_adressenliste (containing all kinds of addresses of people in the sections)
- osv_kl_tl_ausbildung (skills of these people)
I made three list with these three tables, no problem.
osv_vereine to osv_adressenliste is a one to many relationship
osv_adressenliste to osv_kl_tl_ausbildung a 1:1
Also the forms work well. Displaying the information and editing existing people works fine.
Adding a new person though doesn't really work. Adding a person seems to work. If I try to edit the person I get a duplicate key error from the skills table.
What I would like to do is that I can add people, at the same time fill out the skills (different group in the form), as well as also add just the address and a couple of weeks later add the skills.
The skills group is normaly hidden. It is made visible with the right top most radio button setting KL/TL to ja.
It seems the me that there is a problem in the join of the tables.
I add a couple of pictures.
List = showing an overview of data from all three tables
Join = Join statements used
Detail = result (skills group at the very bottom "Technische Ausbildung")
Can you give me a hint?
Thanks
Roger