AnsweredAssumed Answered

combine tables in report

Question asked by curtisn@pcsproductions.com on Oct 23, 2012
Latest reply on Oct 23, 2012 by curtisn@pcsproductions.com

Title

combine tables in report

Post

     I have three central  tables: EVENTS, CREW and EXPENSES.

     CREW fields are name, hours, earings, etc.

     EXPENSES are name, category, amount, etc.

     EVENTS records are populayed with CREW lines (multiple crew members for each event); and EXPENSES (multiple expenses for each event). All  EVENT, CREW and EXPENSES records are all related thoguh _kf and _kp id fields.

     How do I combine related CREW and EXPENSES records related to a single EVENT into one report? jpeg attaced.

     You'll see I've attempted adding a REPORT table for combining, but it isn't working.

     Thanks in advance for any direction!

EventRelations.jpg

Outcomes