Need help connecting different data based on date and customer ID

Hello.  

Hoping someone can point in in the right direction on this.  

Our drivers are assigned routes every day with service stops to customers.  At each stop, they submit a service ticket which is assigned to that customer's unique ID#.  I need to show which stops are made or skipped each day by comparing the Ticket submittals to the scheduled stops. But not every scheduled stop will have a service ticket and there might be multiple tickets for the same account but on different dates.  I put together some example data below.  I would greatly appreciate any guidance on how to combine this for final result.  Thank you!

•  have a scheduled Routes table which shows the Date scheduled, customer ID. 
• I have a Delivery table which shows the date of ticket submittal, Ticket number, and customer ID. 
• And I have a Date table.