Hi,
This is what I want to accomplish
![](http://gobolito.net/struktur.jpg)
As you can see I have two tables with two ChronoForms and one Connectivity. The only thing in this view that I haven't been able to do is the "Filter"-function in CC. I can only filter from one of the tables. I have a few threads about this and have been looking around alot in this forum for this, but I haven't figured it out. There are three solutions for this in my mind:
1. To do a joined search some how, this would be the best solution, in this case I wont need to store redundant data in the contract table.
2. After submit the contract CF a new insert will be done to the Contract table with the same information as the ContractGroup table (by using the GroupId). (Problem is that I can't find a way to do a new insert after submit)
3. Pick data from ContractGroup into inputfields in Contract CF by Ajax.
Thanks
Markus
This is what I want to accomplish
![](http://gobolito.net/struktur.jpg)
As you can see I have two tables with two ChronoForms and one Connectivity. The only thing in this view that I haven't been able to do is the "Filter"-function in CC. I can only filter from one of the tables. I have a few threads about this and have been looking around alot in this forum for this, but I haven't figured it out. There are three solutions for this in my mind:
1. To do a joined search some how, this would be the best solution, in this case I wont need to store redundant data in the contract table.
2. After submit the contract CF a new insert will be done to the Contract table with the same information as the ContractGroup table (by using the GroupId). (Problem is that I can't find a way to do a new insert after submit)
3. Pick data from ContractGroup into inputfields in Contract CF by Ajax.
Thanks
Markus