Create a data sheet that will contain dates and put most recent date in a table

[ka3pmw]

Windows 7 64bit Access 2007



I need to create a form that has the following fields in it:
CallSign, LastName, FirstName, PaymentDate

This form will be searchable by the first three labels and return ALL payment dates. The user will be able to put a new payment date in the form from here too.
It will automatically show the most recent payment date in the Master table.
Each record in the payment table will be exclusive to the person that has that Name.

I used to use dBase when it first came out but that was two strokes and many years ago.

If I am right, I need a table with a relationship to the main database to do this.
What I am not clear on is how to get the payment table for each name and have it show multiple payments. Also not clear on how to get it to show most recent payment date on thee master table.

I have attached the Database to this.
Please help.

[ka3pmw]

Right now there are 140+ members in the club. Will I have to create a separate table for each one with just the dates of each members payments in addition to the master information table then search that table for the latest date and put that date in the master table?