Repeating table

[Ashish]

Hi,

I want to have two repeating tables on my form. However, one should drive
the other. Specifically, if I add a new row to the master one, it should add
a new row to the other one as well. At the end of the process both the tables
will have equal number of rows and columns, but the values of each
corresponding locations of the two tables will be based off a formula. (A
simple mathematical one eg. a= b+ const.)

Can this be achieved in SP1? Any help or suggestion will be really
appreciated.

Thank You,
Ashish

 

[Inbar]

You can write a small javascript that will be run on the event that the table
changes and make the update to the the other table. Is the other table
read-only or can the user change it as well?

 

[Ashish]

The other table is changable too. The bigger picture for this problem is that
we already have a huge form with static number of rows in numerous tables
with logic running like the one I wrote before. I am trying to optimize the
form performance by changing the tables to repeating tables and eliminating
the on_after_change events with introduction of rules if possible.

Thanks,
Ashish

 

[Ozz]

Hi Ashish,

I had exactly the same problem, till i found that i could make one large
table and cut it in two. When you paste the cutted selection further on in
your form, as a second table, it will add a row when you insert one in the
first table.

Kind regards,

 

[Brian Teutsch [MSFT]]

Try using the same table, but having different fields shown in each table.
So you'll have a master table with both a & b fields included. Then insert
it twice, and delete the fields you don't want. Adding a row will still add
the row in the second table, and the "hidden" fields.

Brian

 

[Jono]

When I use Brian's suggestion or Ozz's I get the little "i" by the group name
with the message "Control stores duplicate data". Is this an issue? Will it
affect proper data storage?