I have two tables … | Players | Membership Fees |
Membership fees are based on your age at the beginning of a season and the season start date is stored in the Membership Fees Table.
From the Players table I enter the Name and DOB, id like to lookup the relevent membership fee by checking if the players age at the start of the season fits one of the categories set out in the membership fees table.
Image below might help explain, I want to check the age at the start of the season is less than 16 then its a junior, between 17 and 65 its senior and 66 + its honorary.
I also want to show the fee payable in the Players table.
All help appreciated…