Find from multiple values using info from related table
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.