After a long brake I started to pick up programming where I left. I have a windows from app, which connects to an SQL server to retrieve data about a user.
There is a particular ID which is used to call the data forward, the personal info like name address telephone and email are displayed from, the data base.
There are although two fields’ year and amount which show the status of the subscriptions, e.g. a John Doe has paid 10 dollars starting from 2009 and every year up to 2016.
My application is working correctly and shows all the right data. The issues is that I forgot to add a function in the last two fields where only the last year is displayed. I mean if the value in the year is 2016 then amount is 10 which is for the last entry.
If I put 2010 then nothing happens, either I have to add some smart function which can get the values correct for all the years.
Any ideas for a simple and quick solution to this.