Greetings,
I have a data set with a store with many locations
Search form
store name
manager name
Store A = 1 manager
Store B = 1 manager
Store C = multiple managers
for example
-CORRECT
Store A
123 Somewhere Ave.
wish, RR 80012
manager: Popicle Pop
- CORRECT
Store B
456 Summer Time
Hopefully, DD 80014
Manager: Groovy Man
The Problem:
When I select Store C
The results return all the stores assigned to Store C with manager names, however the stores name and address are duplicated, the manager names are unique.