 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / July 2007Repeating table
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 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? > Hi, > [quoted text clipped - 10 lines] > Thank You, > 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 > 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 [quoted text clipped - 14 lines] > > Thank You, > > Ashish You will need to use code, not rules, to insert/delete a row in another table, when a row is inserted/deleted in the first table.  SignatureGreg Collins [InfoPath MVP] Please visit: http://www.InfoPathDev.com 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 "Inbar" wrote: > 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 [quoted text clipped - 16 lines] > > Thank You, > > Ashish 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, > Hi, > [quoted text clipped - 10 lines] > Thank You, > Ashish 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 > Hi Ashish, > [quoted text clipped - 22 lines] >> Thank You, >> Ashish 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? > 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 [quoted text clipped - 29 lines] > >> Thank You, > >> Ashish |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.