The MRT server behavior can't transfer other option table's column data ?
There are 3 tables ,
Main is Pol table , Option is Item table and Relational Table is PolItem table .
the step :
1. I use WADA wizard to make the insert page
2.In insert page , made a secondary table "A", and make a Recordset(SelectAllItem) which is "select * from item" .
3. In binding panel , drag and drop the proper data into the table "A" .
4. Use "Repeat Selection" server behavior ,so that all data in recordset(SelectAllItem) can show on the page
5.Use Manage Relation Table server behavior ...
6.In the step4 of the wizard, the column `pow2` and `powfee` I use the recordset(SelectAllItem) pow2 and powfee in binding panel .... (that's must be the problem)
7.Test the page , and everything goes well in PolItem table except the pow2 and powfee column .... No matter which rows of data in Item table insert into PolItem table , the value of `pow2`and`powfee` in PolItem tabe is the 100 and 1000 (the first row of Item table)
8. So I made another Recordset(SelectPow2Powfee),and wish to select the right value of `pow2`and`powfee`, but No Luck..
So please help me...
I have tried and error all day long.... I can't solve this problem...
I also tried the repeat region server behavior .. and got all the same results..
the file I upload is the database structure and the insert page ...
please feel free for more information .
Thanks a lot in advance ...
and sorry for poor English ....