AnsweredAssumed Answered

Creating a database to track contacts and event attendance - struggling

Question asked by EmmaFox on Jun 26, 2013
Latest reply on Jun 26, 2013 by philmodjunk

Title

Creating a database to track contacts and event attendance - struggling

Post

     Hi all,

     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.

     Thanks!

      

Outcomes