Creating a database to track contacts and event attendance - struggling
I'm new to filemaker pro and have got so far with my database following online tutorials etc but have got to the point where I'm now stuck. Here's what I'm trying to create:
A database with three main tables as follows:
Contacts - will hold all contact details
Events- will hold all information relating to event such as name, date, venue, etc
Projects - all info about research projects such as project name, description, start and end dates
I will need to link the contacts to each of the other two tables to show who is organising the events and the projects (can be multiple people)
Events come under a project heading so will need to link these tables
Also need to track which contacts have been to which of our events
I have set up an event attendance table which contains an attendance ID, contact ID (FK) and event ID (FK) and set up the relationships for these. I have tried setting up various portals in the contacts and the events tables to be able to link these records and show in the layout that person x has been to events 2, 4 and 7 but I just can't figure it out or get it to work.
I am using Filemaker Pro 12
Any help would be greatly appreciated.