Here is a sample that might work for you. It keeps a running total in "table view'.
Google "team score site:forums.filemaker.com" threads on this site about Team Scores
Tables in the database? the expected tables would be
Team has many games
Team has many scores
Game has two teams which means many
Game has many scores
Join tables connect tables that have many entities
Team --< Scores >-- Game
Home > Designing and creating databases > Creating a database > About planning a databaseAbout planning a databaseA well-designed database promotes consistent data entry and retrieval, and reduces the existence of duplicate data among the database tables. Relational database tables work together to ensure that the correct data is available when you need it. It’s a good idea to plan a database on paper first.Follow these general steps to plan a database:
Relational Database Design 101 (part 1 of 3): Designing a Flat File Database
Relational Database Design 101 (part 2 of 3)
Relational Database Design 101 (part 3 of 3)
The White Paper for FMP Novices is useful -
Thanks to both of you for your replies. Either i wasnt very clear or I wasnt able to find the solution in your responses.
when i enter a new score record it recalculates both the running score and the margin,
The calculation is applied to all of the records rather that just that particular record. What i want is something like below:
Goal=6, Behind =1
Record 1 - Team A scores goal, Running Score Team A = 6, Running Score Team B = 0, Margin = 6
Record 2 - Team A scores goal, Running Score Team A = 12, Running Score Team B = 0, Margin = 12
Record 3 - Team B scores goal, Running Score Team A = 12, Running Score Team B = 6, Margin = 6
What i am getting is:
Record 1 - Team A scores goal, Running Score Team A = 18, Running Score Team B = 6, Margin = 6
Record 2 - Team A scores goal, Running Score Team A = 18, Running Score Team B = 6, Margin = 6
Record 3 - Team B scores goal, Running Score Team A = 18, Running Score Team B = 6, Margin = 6
Here is a screenshot of what is happening with the portal
Can i get the calculations to "freeze" for each record and not update when a new record is added?
Screen shot didnt add...
It does not appear that you have selected the "running total" option for your running score summary fields--assuming that they are summary fields as they should be for this project.
Thanks Phil - solved my problem beautifully
Sorry. Somehow the wrong sample file got attached to my post.