AnsweredAssumed Answered

Need help with table view

Question asked by ReidCamp on Apr 25, 2013
Latest reply on Apr 25, 2013 by philmodjunk

Title

Need help with table view

Post

     Hello all,

     I would like to have a table in my database that shows ALL the data. The tables in my DB are hierarchal, so I would like to group the data by the highest level table's ID ("SurveyInfo_ID").

     In access, I would simply create a totals query and group by "SurveyInfo_ID." However, I'm not sure how to do this in FM.

     In other words...

     Here is what I want my table to look like:

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
                    SurveyID                     Crew                     Year                     Location                     StationID                     Date                     Attempt                     Control
                    1                     RC                     2013                     Here                     45                     4/25/2013                     1                      
                    1                     RC                     2013                     Here                     45                     4/25/2013                     2                      
                    1                     RC                     2013                     Here                     45                     4/25/2013                     3                      
                    1                     RC                     2013                     Here                     45                     4/25/2013                     4                      
                    1                     RC                     2013                     Here                     45                     4/25/2013                                           1
                    1                     RC                     2013                     Here                     45                     4/25/2013                                           2
                    1                     RC                     2013                     Here                     46                     4/25/2013                     1                      
                    1                     RC                     2013                     Here                     46                     4/25/2013                     2                      
                    1                     RC                     2013                     Here                     46                     4/25/2013                                           1
                    2                     RC                     2013                     There                     47                     4/25/2013                     1                      
                    2                     RC                     2013                     There                     47                     4/25/2013                     2                      
                    2                     RC                     2013                     There                     47                     4/25/2013                     3                      
                    2                     RC                     2013                     There                     47                     4/25/2013                                           1
                    2                     RC                     2013                     There                     47                     4/25/2013                                           2
                    2                     RC                     2013                     There                     47                     4/25/2013                                           3

     Here is what it currently looks like:

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                    SurveyID                     Crew                     Year                     Location                     StationID                     Date                     Attempt                     Control
                    1                     RC                     2013                     Here                     45                     4/25/2013                     1                     1
                    1                     RC                     2013                     Here                     46                     4/25/2013                     1                     1
                    2                     RC                     2013                     There                     47                     4/25/2013                     1                     1

     FYI, there are many more fields, this is just an abridged example of what I want to accomplish.

     Thanks!

Outcomes