Nested queries - InfoPath Dev
in

InfoPath Dev

Nested queries

Last post 10-09-2012 06:02 PM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 10-04-2012 10:21 PM

    Nested queries

     Hi there,

    Please refer to the attachment for the modelling of my DB.

     

    What I'm trying to achieve is a form that displays the following:

    1.  provide the users with a list of servers to select from (done, I'm populating a multiple-selection list box (multServers) with data fed from the DB ([Table ABC].Column Server )
    2. display all applications installed on selected servers (done, I created a repeating list (bound to the "Table DEF" table) with the following conditional formatting statement "count(@ServerName[. = xdXDocument:get-DOM()/my:myFields/my:group1/my:multServers]) != 1"
    3. Display the Change Window of each application

    That's what I'm currently struggling with (3). I basically need to display the Change Window when Table XYZ.Column Application = Table DEF.ApplicationName AND Table DEF.ServerName = multServers (the select items of the check box).

     

    Any leads would be appreciated.

     

    Cheers,

    Adri

     

     

     


  • 10-09-2012 06:02 PM In reply to

    Mind sharing your form? It is a little hard to help without knowing more about the data structure.

    Hilary Stoupa

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