I would also add, do not have same field names in different tables. Confuses the hell out of Access.
MemberID in Payments could be MemberIDFK if only the one, or MemberIDPayFK is you have MemberID in other child tables. Something at least to differentiate.



FK is for Foreign Key, which is what they are.