AnsweredAssumed Answered

Three Tables/One Relationship/Attempting to pull back all related data but only getting 1st related...

Question asked by ambertwist on Jul 28, 2010
Latest reply on Jul 28, 2010 by philmodjunk

Title

Three Tables/One Relationship/Attempting to pull back all related data but only getting 1st related record

Post

I am working on a layout/report in FileMaker Pro 11. I have 3 tables that are related by Month. I am trying to use the month in Table 1 to pull back the details from the corresponding month in Table 2 and Table 3. I have set up multiple areas for the data to populate but it is only bringing back the first record from each table multiple times instead of recognizing there are more than one related records within the tables. So in Table 1 I only have the month May listed once but in Table 2 and Table 3 I have more than one record with the month, May. I want to see all records with the month of May from both Table 2 and 3. This is not a complicated database so I am unsure of what I am doing wrong. Any suggestions?

Outcomes