How can I build a One-to-Many relationship?

[Candyce_Fulford]

I’m using Airtable to build a list of donors for our non-profit organization. The records are identified by the name of the donor. Some donors make multiple donations throughout the year. How can I reflect these frequent donations without building a whole new record?

Thank you so much.

[kuovonne · Accepted solution]

You need two tables. A table for donors, and a table for donations. Join the two tables with a linked record field.

Each new donation gets a new record in the Donations table. If the donor already exists in the Donors table, link the donation to that donor. If the donor does not yet exist, create the donor record.

[Candyce_Fulford]

Thank you! Thank you! I thought it might be something like that but I couldn’t wrap my head around it. You are a life saver!!