AnsweredAssumed Answered

Need advice on setting up a report

Question asked by user17152 on Oct 7, 2014
Latest reply on Oct 8, 2014 by philmodjunk


Need advice on setting up a report


I'd like some advice on setting up a report.  I have three tables:

  1. TroubleTickets
  3. PunchItems
  5. PunchReceivables


There is a one-to-many relationship between TroubleTickets and PunchItems and a one-to-many between PunchItems and PunchReceivables.  I want to generate the following report:

Trouble Ticket #1

Attn: John Smith

Punch Item #1

Punch Receivable #1

Punch Receivable #2

Punch Item #2

Punch Receivable #1

Punch Item #3

Punch Item #4

Punch Receivable #1


Not all PunchItems will have related PunchReceivables, as illustrated in #3.  I can't get this to work.  I can get a list of my PunchItems on the TroubleTicket and the first PunchReceivable will show up, but not a list of PunchReceivables.  Is such a report not possible?  I've tried various combinations of sub-summary and changing the table reference for the layout between the three tables.  Nothing works.

I'm pretty bad at FileMaker reports and would appreciate some guidance.  I've thought about using the List function in a calculated PunchItems field to generate a list of PunchReceivables.  But I wasn't sure if that was the best approach, so I thought I'd ask here first.

Thank you!