problem in Cascading listbox--current() - InfoPath Dev
in

InfoPath Dev

problem in Cascading listbox--current()

Last post 10-01-2005 01:28 AM by Sreedharsrvv. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 09-30-2005 05:43 AM

    problem in Cascading listbox--current()

    Hi,
    I am developing a new InfoPath form for TimeSheet Entry .I am having repeating section,which contains two drop down list boxes and and one text box.
    One listbox is for secting ModuleName (This is connected one of the table in access database,where all module names will be stored).other listbox will contain Activity which currently doing in that module (for example analysis ,design,coding,testing etc,this data is existing in some other table).
    Based on the ModuleName which is selected in the first list box,corresponging activities should be displayed in the second list box.
    So i need to use cascading listbox here,since its a repeating section,i used a filter like this ModuleName(second table) is equal to current()/ModuleName (first table) or @ModuleName[current()]

    while i am selecting second record in run form,my second listbox is displaying Activity values of both first ModuleName and second ModuleName(Module name which i selected in second row while inserting row at run form).
    After selecting all these values i need to submit to some other database in access.
    Please help me in solving this.
  • 10-01-2005 12:45 AM In reply to

    Re: problem in Cascading listbox--current()

    Hi Sreedharsrvv,
    I'm not sure I understand the problem you are having. Have you tried doing the work you describe, or are you looking for someone who has a solution already? Sorry for my confusion.

    Patrick Halstead [InfoPath MVP]
    InfoPathDev
    Patrick Halstead
    Project Manager at Qdabra
  • 10-01-2005 01:28 AM In reply to

    Re: problem in Cascading listbox--current()

    Hi Patrik,
    Sorry for the confusion which i created.
    This is regarding the probelm of cascading listbox.
    My two list box is pointing to two different tables in database.
    Based on the values which i selected in first list box ,i need to make a comparion on second table and retrive corresponding values only.
    Assume first list box (or first table ) contains "ModuleName" as column
    and second list box (or second table) contains "ModuleName" and
    "Activity" as columns.
    When i select some ModuleName in first list box,it need to make a comparison on second table with "ModuleName" and retrive "Activity" columns values.
    I am using filter like this ModuleName(first list box) is equal to @ModuleName[current()] .
    Still when i am inserting second row in run form,my second list box contains Activities values of first row and second row.
    I read in forum at so many locations use current().
    But this is not working with me.
    How to do this.
    Thanks for ur help .
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.