AnsweredAssumed Answered

Table relationship problems

Question asked by user14040 on Sep 15, 2012
Latest reply on Sep 16, 2012 by user14040

Title

Table relationship problems

Post

     I have three tables

     MainInterface, ServiceReport, Equipment 

     I am trying to get data to show in portals from Service Report and equipment within the same tabs.

     layout MainInterface is basically an  empty table that I use to fill the ports in the tabs

     See this link for Portal Tabs image http://db.tt/b8jO6EdD

     What I am trying to do is get  all the data that says open to show on the portal 

     The problem is it shows the different data from the ServiceReport has shown in the blue buttons and the word Open

     but it's repeating the data from the equipment table (FSRPRO_Rockwood is shown on all three rows) this information should be different.

      

     Here is an image of the relationship I am using http://db.tt/zbCk8o8V

     the portal is based on ServiceReport2 

     MainInterface::ServiceReportIDfk : ServiceReport 2::ServiceReportIDfk ( with autodata set at 1)

     ServiceReport 2::EquipIDfk6 : Equipment 6::EquipIDfk6 (with autodata set at 1)

     I am trying to get the data from Service Report and Equipment to show up in the same portal.

     Portal is filter to just show field reports that equals "open" as you see from this image http://db.tt/b8jO6EdD

     it shows the different data from table ServiceReport 2 but shows the same data from table Equipment 6

     Cant seem to figure it out.

      

     Thanks

Outcomes