I have 2 tables, 'contact list' & 'transactions', and every few months people in the contact list pay their fees. What I would like to do is have a form that shows everyone in the contact list with blank fields from the transaction table so that I can enter transactions for the ones that have paid. My tables are structured as detailed below.
Contact List - pID, First Name, Last Name
Transactions - ID, pID, Date Paid, SessionNo, ChequeNo, Amount
I attach a stripped down version of my DB.