Tracking attendance at multiple events over time
I'm new to Filemaker Pro. So far I've managed to create a database for the membership of a professional network I manage, giving each member a MemberID key.
I have an Excel spreadsheet indicating which members attended our many events over the years. I cannot for the life of me figure out how to get this information into my database. I've figured out that this is a many to many relationship (each member has been to multiple events; each event is attended by multiple people). I've given each event an EventID key, with the idea that somehow I can create a join table. (I'm including a screen shot of that EventID and MemberID table in Excel.)
But that's as far as I can get. I'm sure I'm missing something really obvious; I just can't figure out it with my limited knowledge of Filemaker Pro, and the Missing Manual I'm using doesn't give me enough info.
Thanks for any guidance.