AnsweredAssumed Answered

combining table into one report

Question asked by hwachai on Dec 17, 2013
Latest reply on Mar 18, 2014 by PhilHarper

Title

combining table into one report

Post

     

          projects A ----- task table A ( task title, user, status) 

     

                                   task table B ( task title, user, status)

     

                                   task table C ( task title, user, status)

     

          projects B ----- task table A ( task title, user, status) 

     

                                   task table B ( task title, user, status)

     

                                   task table C ( task title, user, status)

     

          ----------------------------------------------------------------------------

     

          I have main projects table, each project create different task table base on current project id. And each task table have its own task list....

     

          now my problem is to create a report showing the project with all the task.... like combining the task table into 1 list

     

          ---------------------------------------------------------------------------

     

          project A

     

          title   l   user    l   status  (sort by status)

     

          project B

     

          title   l   user    l   status (sort by status)

     

           

     

          I m new on using filemaker pro 12. I recontructing the database input for my department next year, to replace current database structure that done by previous manager... really appreciate your help.

     

           

     

          thanks

     

          hwachai

     

           

     -----------------------------------------------------------------------------------------------------------------

     I think my explanation not clear enough, here is more detail information.... each task table have its own drop down menu and other specified fields.

      

projects A -----  task table A ( task title - drop down menu, user, status, material, size) 

                                task table B ( task title - drop down menu , user, status, contact, function)

                                task table C ( task title - drop down menu, user, status, layout )

                                task table D ( task title - drop down menu, user, status, duration, video size )

      

projects B -----  task table A ( task title - drop down menu, user, status, material, size) 

                                task table B ( task title - drop down menu, user, status)

                                task table C ( task title - drop down menu, user, status, layout )

                                task table D ( task title - drop down menu, user, status, duration, video size )

      

     The reason to separate all my table because, if I only create one record with so many details will be quite confusing.... I have total 9 task tables, each table have more than 15 tasks.

      

     Now my people need one report to keep track all the tasks for each project like below : -

      

project A

            title          l      user       l        status  (sort by status)      <---- i only need this 3 field

     -      Task AAA           Jimmy               in progress       (from table task A)

     -      Task BBB           Jimmy               in progress       (from table task A)

     -      Task CCC           Henry               in progress      (from table task B)

     -      Task DDD           Sandy              in progress       (from table task B)

     -      Task EEE           Victor               in progress       (from table task C)

     -      Task AAA           Sam                 in progress       (from table task C)

     -      Task BBB           Victor               in progress       (from table task C)

     -      Task CCC           Siva                in progress       (from table task D)

     -      Task DDD           Tony               in progress       (from table task D)

     -      Task EEE           Jimmy               in progress      (from table task D)

      

project B

     -      Task AAA           Jimmy               in progress       (from table task A)

     -      Task BBB           Jimmy               in progress       (from table task A)

     -      Task CCC           Henry               in progress      (from table task B)

     -      Task DDD           Sandy              in progress       (from table task B)

     -      Task EEE           Victor               in progress       (from table task C)

     -      Task AAA           Sam                 in progress       (from table task C)

     -      Task BBB           Victor               in progress       (from table task C)

     -      Task CCC           Siva                in progress       (from table task D)

     -      Task DDD           Tony               in progress       (from table task D)

     -      Task EEE           Jimmy               in progress      (from table task D)

      

( click on the task title with direct to task detail )

     Please, need help on this. Combine the info into one table? get value from each table? can it be done using report / calculation by name?

      

     Thanks!!!

     hwachai                     

Outcomes