combine tables in report
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!