So we really like the calendar in the Queries module QU-B (Calendar Drill Down) however it is not very practical.  
 
We need the ability to search under a part number and then have the calendar display the corresponding purchase orders, work orders and sales orders all related to that part number.  
 
Right now I provide our production manager and shipping manager with an excel calendar by month and imput the open sales orders including part number and quantity, then the shipping manager imputs the work orders and the production manager imputs the purchase orders. We were really excited at the possibility of this calendar to eliminate our current process, but we would want to see all types of orders related to the particular part number. Is there a way it can be modified?