Problem in Joining tables in QV

[#1]

Hi ,

              I have some tables..........

   1) AppServer Table

            --Server ID

            --Appl ID these are columns

  2) Server Table

          --Server ID

         -- server name.........etc some other columns

  3) Software Tabke

              -- server ID

              --software name

             -- software name....etc

  4) Apptech Table

             --Appl ID

             --Appl Name...etc

like this i have some other tables using these tables i have created some charts and tables.

From charts if i select server name it is updating with what all are the server softwares and application under that server and

if  i select applname from any object charts should update with what all are the softwares using for that application and it should update with related servers but it is not updated with the related details. so please give me your suggestions.

sorry due to some reasons am not able togive the sample file or data

Regards,

Anil

[jagan]

Hi,

Sorry, for the late reply, I am little bit busy.  Can you attach Table mapping diagram, so that it would be helpful to analyse.

Regards,

jagan.

[jagan]

Hi,

I am not sure about the issue, when I checked the mapping diagram, there are mappings between Server, Application and Softwares.  When you select any of this everything should be updated.

Best way to solve is minimize the tables, first add the base tables and then check, if it updates then add the remaining tables.

Regards,

Jagan.

[#4]

Hi Jagan,

             I have added three tables only but still all 3 tables no gettin update any ideas??