AnsweredAssumed Answered

Need help with table view

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

Like • Show 0 Likes0
Comment • 3

Title

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!

No one else has this question

Outcomes

3 Replies

philmodjunk Apr 25, 2013 4:22 PM
Mark Correct
Correct Answer
     It would help to have a more complete understanding of how your data is structured. Please explain the differences in the last two columns and how they are produced in your first example.

     Are you grouping your data by the first 5 or 6 columns? are the values in the two right columns running totals?

     If so, this can easily be produced with a List View, not Table View layout using summary fields set to compute running totals and the correct sort order.
Like • Show 0 Likes0
Actions
ReidCamp Apr 25, 2013 4:45 PM
Mark Correct
Correct Answer
I have tables structured like this:
1.           SurveyInfo
  
                             StationInfo
  
                                        Attempts (portal)
  
                                                 Attempts information
  
  
  
                                    Controls (portal)
  
                                                 Controls information
The attempts and controls information is filled in using portals in the StationInfo layout.

When a person uses this form they will:
1. Fill out the survey info (name, date, place)
2.           Fill out station info (will be multiple stations per survey)
  
                             Fill out attempts and controls (will be multiple attempts and controls per station)
     I would like to be able to group the data by individual surveys which each have their own unique ID.

     The examples above are conceptual - I made them in excel.

     Sorry for the poor formatting above - the bullets and numbers are not working properly...
Like • Show 0 Likes0
Actions
philmodjunk Apr 25, 2013 9:54 PM
Mark Correct
Correct Answer
     I would like to be able to group the data by individual surveys which each have their own unique ID.

     Then I'm still not understanding what you want here. Both tables appear to be grouped by survey ID--the first column in both tables. This does not explain what is supposed to be different between your two examples.

     I think you should investigate summary reports which are created in List View: Creating Filemaker Pro summary reports--Tutorial

     But I could easily be misunderstanding your.
Like • Show 0 Likes0
Actions

Need help with table view

Title

Post

Outcomes

Related Content

Recommended Content