I am attempting to track gym equipment use by membership. A Member can have several Memberships (once one expires they can purchase another) but I want to link all equipment use that occurs in one membership together. I have the following tables
TblMember
MemberID, LastName, FirstName, Age
TblMembership
MembershipID, MemberID, StartDate, PaymentType, ExpirationDate
TblEquipment
EquipmentID, MembershipID, Machine, Duration, Location
I’m a novice so I don’t know what to do to make this happen or even if it can happen.