Please refer to the attachment for the modelling of my DB.
What I'm trying to achieve is a form that displays the following:
- 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 )
- 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"
- 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.