HTTPS://forum.openoffice.org/en/forum/viewtopic.php?=104384
I have modified the above to suit my league. So far it is all working well.
I would like to take it a little! further.
I have added a players table, with player_ID as the primary field. My intention is to allocate the player to the match in a new table (180s_table), when a 180 is scored (I am recording darts matches)
I am going down a bit of a rabbit hole with the cascading list boxes. The existing example cascades by season, then match weeks. I need to go further. Cascade by match_ID, team_ID, and then allocate a player_ID. I’m intending to use the filter table and have added the additional fields.
I’m disappearing into sub form after sub form with no solution. How do I populate the filter table with the options required to allow the final score table to be updated?