First and foremost, you can produce a summary report of the table itself, summarized by PlayerID and by Level. There are several ways you can summarize the Attempts table. Player_ID is the Primary key on the PLAYER_SUMMARY_TB and a foreign key on the PLAYER_ATTEMPTS_TB.įirst, your "summary table" is basically a Players table and it would be best to treat it as such - for example by including the player's names in it (once) instead of repeating them in the Attempts table. I am not sure what I’m doing wrong? The two tables are linked using the Player_ID. This shows me the correct results with the above if statement but as soon as I change the condition to “Level 2”, I do not get any results back.
In the “PLAYER_SUMMARY_TB” Table, I have made the score fields Calculation type and I have entered the following: If( PLAYER_ATTEMPTS_TB::Game_Level = Level 1 Max(PLAYER_ATTEMPTS_TB:: Score)) The two tables have a relationship, Linked by the Player_ID field. Summary_ID >Player_ID > Player_Name > Level1_Score > Level2_Score > Level3_Scoreġ Player001 > John Smith > 55 > 60 > 70Ģ Player002 > Simon Cowell> 55 > 60 > 70 So on the table below I show the summary for all of the levels. So what I’m tryin to do is create a summary table that shows all the attempts that are equal or above 50 for each player. For example let's say this is my table in filemaker Pro 12 Table Name(PLAYER_ATTEMPTS_TB)Īttempts_ID >Player_ID > Player_Name > Game_Level > Scoreġ Player001 > John Smith > Level 1 > 30Ģ Player001 > John Smith > Level 1 > 40ģ Player001 > John Smith > Level 1 > 45Ĥ Player001 > John Smith > Level 1 > 55ĥ Player001 > John Smith > Level 2 > 26Ħ Player001 > John Smith > Level 2 > 40ħ Player001 > John Smith > Level 2 > 45Ĩ Player001 > John Smith > Level 2 > 60ĩ Player001 > John Smith > Level 3 > 30ġ0 Player001 > John Smith > Level 3 > 40ġ1 Player001 > John Smith > Level 3 > 48ġ2 Player001 > John Smith > Level 3 > 70
Table 1 records a player’s quiz attempts (Players proceed’s to the next level if score is equal or above 50). I am having trouble viewing a summary of all the attempts.
0 kommentar(er)
