AnsweredAssumed Answered

relational databases

Question asked by ALynch on May 15, 2011
Latest reply on May 16, 2011 by philmodjunk

Title

relational databases

Post

Hi - I am trying to create a relational database and have not had that much experience with FM Pro although am pretty computer literate.  My tables I have set up as follows:

TABLES:

Events Master     Contacts Master     Attendance

All my data needs to be imported by csv files from excel.  The Events list has an Event ID # for each event. 

What I want to create is a relationship from the Event table to the contacts table that auto fills the events details in the contacts table.   My contacts spreadsheet also contains the event ID. I have set up an auto fill function on each of the event master fields to fill into my contacts  table but it is not filling any of the info in when I import my csv file.  Below is a screenshot of my relationship graph.  Maybe someone can tell me where I am going wrong.

Also ecause participants attend a number of events, I want only one contact entry for someone who may have attended a number of differnt events.

I tried with the starter solution but it was way too complicated and I did try to find some step by step instructions on how to complete the events starter solution.  If anyone knows where I can find these please let me know.  I think though my problem is that I am uploading the information from spreadsheets and not just directly entering the information into the database.

Any help would be greatly appreciated.

A

Picture_4.png

Outcomes