I am making a database through access for a church. Most of the time, couples tend to donate a sum but sometimes they may choose to donate individually for specific fundraiser events.

I am very rusty in MS Access so less VBA/SQL would be great. (Last time using access was in high school)

So far I have two rough tables, tb|Contacts and tb|Donations. I have thought of changing the primary key in tb|Donations to ContactID and allowing DonationID to have duplicates but realised I wouldn't know how to entry forms for couple donations.

Would it be wiser to create a single Contact as a couple or is there an easier way that I am missing?