Database start

starting a database with ID page (names etc) contributions page and event page. Not understanding the connecttion to make it relational. Any ideas?
have used Access and FileMaker but need this in Excel so available to all users and cross platform

It is not clear what your question is. You have three sheets with data but you haven't described what any of it means or what you want to do with it.

If we look at this as a relational database, Sheet Events has the foreign key "member ID" referencing the primary key in Master sheet, which is fine, but what do you want to do with it?

Sheet3 has Contributions with primary key contribution[sic] ID, but what do you want to do with it?

Hi mmburke and welcome to the forum,

Perhaps this site will explain what you want?
https://support.office.com/en-us/art...9-8A3848820BE3

I'm always amazed at Excel having functions I've needed but never knew about, once I find them. I hope this question has a solution already in Excel.

If you have Excel 2016 or more recent then Get & Transform in included. If you have the 2010 or 2013 version then Power Query is a free download from Microsoft. (Please put the Excel version in the profile for MS-Off Ver: )
Using Power Query you could:
1. Convert the range on the Events sheet to a table (tblEvents)
2. Make connections to the three tables in the workbook by selecting the Data tab > From Table/Range > (Power Query Editor) Close & Load to: > Only Create Connection
3. Merge the three connections using the following advanced editor code:

let
    Source = Table.NestedJoin(Master, {"member ID"}, tblEvents, {"member ID"}, "tblEvents", JoinKind.LeftOuter),
    #"Expanded tblEvents" = Table.ExpandTableColumn(Source, "tblEvents", {"MOMA", "Circus", "Show", "Garden"}, {"MOMA", "Circus", "Show", "Garden"}),
    #"Merged Queries" = Table.NestedJoin(#"Expanded tblEvents", {"member ID"}, SSales, {"contrubution ID"}, "SSales", JoinKind.LeftOuter),
    #"Expanded SSales" = Table.ExpandTableColumn(#"Merged Queries", "SSales", {"Quarter1", "Quarter2", "quarter3", "quarter4"}, {"Quarter1", "Quarter2", "quarter3", "quarter4"})
in
    #"Expanded SSales"

Let us know if you have any questions.