repeating table problem - InfoPath Dev
in

InfoPath Dev

repeating table problem

Last post 04-28-2010 12:19 PM by sharepoint99. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 04-28-2010 06:29 AM

    repeating table problem

    Hello,

    I have a repeating table in which 4 columns are there ..my requirement is that when user fills in say the first column which is the id the other three should autopopulate and this will happen when user fills in the id and click a button..what i did was i created a web service which takes the id value of the first column passes it to the web service and the web service gets data from the sql server 2008 database and it's working fine and getting and showing data

    The problem

    In the repeating table when i fill in the first row then i get the values back from database..but when i insert another item and insert another id the first row id also changes and becomes of the same value as the second one and this process follows so if say i have filled 4 rows of the repeating table then in the whole table i will have 4 rows having the same data as the last row...can somebody tell me how to get different values for different id's entered in the repeating table..

    Thanks

  • 04-28-2010 10:40 AM In reply to

    Re: repeating table problem

    Hi SharePoint99,

    You need to look at using current() when you set your field. Greg Collins has a bunch of posts on how to use this. Check out his blog on this site and search for current. Here's one example: http://www.infopathdev.com/blogs/greg/archive/2004/07/08/Identify-the-Current-Table-Row.aspx.

    Happy days!

    Patrick Halstead
    Project Manager at Qdabra
  • 04-28-2010 11:08 AM In reply to

    Re: repeating table problem

     Hello Patrick,

    Greg posts were not detailed as such and i am not an infopath developer as such so could not understand the XML code he had.I also cannot see the function Current()..below is the detail of m problem..can you suggest me a simple solution

    The problem

    In the repeating table when i fill in the first row then the value of this first row is passed to a web service which  gets the values back from database and populates the three fields..but when i insert another item and insert another id the first row id also changes and becomes of the same value as the second one and this process follows so if say i have filled 4 rows of the repeating table then in the whole table i will have 4 rows having the same data as the last row. ie  it is updating all the rows based on the value entered in the student id and i want that it should update only the specific row..

    Thanks

    eg

    employee id    First_name   Last_name  Position

    1                   gavin            paul          manager

    2----------now when i insert 2 in the repeating table what it is doing is that it is updating the 1 also to two and showing values related to ID 2 but i want that for 1 it should show 1 and for 2 it should show values related to 2...

    I want to know what exactly do i have to do like add event code or rules or what...i am using Browser enabled infopath 2007.... any help is much appreciated.

     

  • 04-28-2010 12:19 PM In reply to

    Re: repeating table problem

     Patrick i see in this link http://office.microsoft.com/en-us/infopath/HP011552811033.aspx    that current() is a function in infopath but it is not there when i go to insert function in my Infopath 2007 browser enabled form...do we have to install something to get this function.

Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.