I have a table that I have set up to show other related tables for that customer (Visits, Jobs, Notes) I like the way this looks. However I need to integrate those tables together in one database so I can send a report at the end of the day with Visits Jobs and Notes for the day. I am wondering how I can make a slice that pulls the information for Jobs show like I have it as if it was a related table for the customer. I can make the slice but am having trouble with the UI portion.
I am doing this so I can send the report, but maybe there is a way to link to different tables in the report that would be easier. I would like to hear some thoughts on the best way to do this.