So I have a tabled called: Publishers. On that table I have a link/report to a separate table called Contacts. These are the contacts related to the publisher.That works fine. I have a report on the Contact table called: For the Publisher Table and this shows up properly.
I have a third table called Publications. This show the publications related to the publisher
Now I want the contact report (For the Publisher Table) that shows up on the Publisher table to also show up on the Publication table and be attached.
Publisher name is Budget Travel.
They have a contact name Jane Smith.
She has two publications called Budget Travel Cruises and Budget Travel Road Trips. On those two publications records, I want the report of all related contacts to that publisher to show. How do I do that?