AnsweredAssumed Answered

Find from multiple values using info from related table

Question asked by AlexE on Feb 11, 2014
Latest reply on Feb 11, 2014 by AlexE

Title

Find from multiple values using info from related table

Post

     Hi, 

     I hope I'm clear and this is probably fairly simple but I've been struggling to fix this. 

     I have 2 tables. SALES_DATA and STORE_INFO

     SALES_DATA is a list of items and associated sales information (SKU, description, STORE_NUMBER...)

     STORE_INFO has territory details of each store, each store has it's own record and contained in each record is (STORE_MANAGER, REGIONAL_MANAGER...)

     What I want to do is select a REGIONAL_MANAGER (checkbox, drop down list... doesn't matter how) and display all the items from all the STORES located in the REGIONAL_MANAGER's territory)

     I'm drawing a blank. The store numbers from SALES_DATA & STORE_MANAGER are related.

Outcomes