AnsweredAssumed Answered

Need direction on defining relationships

Question asked by chucktarver on Jun 7, 2013
Latest reply on Jun 7, 2013 by chucktarver

The last version of FileMaker Pro I used was FMP7 to design a database for a community radio station. It was a flat database that tracked contributors. It has been used for many years and requires volunteers to retype contributor data each year. I'm hoping to create a relational database that will do several things. 1.Allow volunteers to look up data from a contributors table so they do not have to type it in each year. 2. Track contributions by program. 3. Accurately track "premiums" gifts to contributors. Here are my problems. Contributors often give to more than one show. Additionally, contributors often collect more than one gift. I watched Cris Ippolite's relational FMP12 session on While helpful in understanding the power of FMP12, it has left my head swimming trying to resolve the many-to-many conflicts I have with these two areas. Diagramming help and advice, greatly appreciated.

Thanks Chuck