Adding up years of service

[Freddo]

I'm setting up a registration database for soccer but need to tally each
players years in service. So when they register next season it adds another
year to their service record but also shows what years they ? How do I do
this without making the form cumbersome. Should there be a table that is
linked to the main database that shows their service record and if so how
would I set it up.

 

[Vincent Johns]

I'm setting up a registration database for soccer but need to tally each
players years in service. So when they register next season it adds another
year to their service record but also shows what years they ? How do I do
this without making the form cumbersome. Should there be a table that is
linked to the main database that shows their service record and if so how
would I set it up.

Yes, you could do it that way. I can think of a couple of ways; for
example, each record in the new table could consist of 2 fields:
player's identity (= many-to-one link to the main [Players] table), and
season identifier (could be the year number, such as 2004).

Or, each record could include the player's identity (1-to-1 link) and a
collection of checkboxes (yes/no values), one for each possible year.
But it would be a little trickier to add up total years with this design.

What you show on the form should be a subset, I think, assuming that
most of the records that you add this year will be for this year, not
prior ones. You could have a form that asks the user to select a set of
names (each of which will consequently be added to the new table with
this year's date).

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.