I have two tables:
Coverage with AgentID, zip, city, state, cbsa - each agentID will have 100’s of rows listing all areas covered by an agent.
Activities with AgentID, activity, leadID, leadDate, activityDate - this table will have many rows for each agent and each lead assigned to them
I am trying to use the coverage table to filter for a particular market area (CBSA) and then filter the activities to only the agentID’s returned from the coverage filter.
I’ve tried using controls with “show relevant data”, but that seems to only work if I’m passing the CBSA field.
Any ideas?