Bundesliga add goal scorers

English
#1

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?

#2

so far the response from:

#3

I think I might have only pasted half a link.

https://forum.openoffice.org/en/forum/viewtopic.php?t=104384&sid=55d1d448f515a245e9602df2c23314d5

#4

Is dart a team sport? I have no idea, but PDC World Darts Championship 2025 – Wikipedia shows 66 individuals participating in the current world championship. So the names of “Clubs” in my database would become names of individuals. No need for cascading list boxes because you don’t have to filter the players by their club memberships since the players are the clubs.
The current season (year number) is stored in the filter table’s record where FID=0. The Bundesliga sample data include the years 2018-2020. Having the year number 2018 in column SINT of that filter table, query lb_Clubs shows all clubs participating in the 2018 tournament.

#5

Yes darts can be a team sport. It is in our small local league. I have attached my modifications to your Bundesliga database. Some forms work, some do not.

I have added my fixtures for this year to the matches table.

The forms which work are the “Enter_Scores_frm” and the “View_Matches_Season_Results_frm”

The scores are entered for the home team, with a maximum of 23 points awarded (13 for darts and 10 for dominos) The away team scores are calculated from the home team scores.

The form would I like to be operational is the 180s_frm where I would like to be able to enter team and player IDs into the 180 table. I can enter the match ID by selecting the relevant row from the match table, but I can not refine the drop down in the 180 form to show the two teams. Once the team has been confirmed the player would be selected from the players associated with the previously confirmed teams.

I hope the file can explain a little better. This is very much a work in progress.
Bundesliga_Darts.odb (173.6 KB)

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.