How can I automatically update the data in a record when I create a new record in a different table?

I have a table called Member. In this table is a field called NoOfLessonsBooked. When a Member has booked a total of 10 lessons, they should get a free lesson. I have another table called Booking, which stores details of all the bookings that have been made. Every booking includes a MemberId for the member who made the booking. I want the NoOfLessonsField to go up by 1 for every record in booking that includes the MemberID of a member. So every time MemberID 1 makes a booking, I would like MemberID 1's record in the member table to update it's NoOfLessonsBooked by 1.

Here are the 2 tables in question:

Member Table

Bookings Table

You could use an After Insert Data Macro on the booking table that updates the Member table and increments the NoOfLessonsBooked. You might also consider an Delete trigger on the booking table to subtract 1 from Member.NoOfLessonsBooked.

To create a Data macro that captures the After Insert event, use the following steps.

1. Open the table for which you want to capture the After Insert event. [Bookings]

2. On the Table tab, in the After Events group, click After Insert.

An empty data macro is displayed in the macro designer. Add the following Action blocks:

Look up A Record in Member
Where Condition = [MemberID] = [Bookings].[MemberID]
EditRecord
   SetField
            name [Member].[NoOfLessonsBooked]
            value = [Member].[NoOfLessonsBooked] + 1
End EditRecord

see this question for more details