Forum Discussion

JasmineSexton's avatar
Qrew Member
3 years ago

Need help building a relationship between counties in multiple districts !!!!

I have two tables, a district and a county table. I currently have a relationship where there is more than one county per district. I want the total number of counties to report under their corresponding district. The tricky part is for counties that are in more than one district, how can I get this county to display in both districts? Right now I'm using a multi-select text field for district selection. 

Example: County A is in District 1 and 2, my current setup allows me to pick either district 1 or 2, or create a new district called "1&2". However, I want County A to report in BOTH district 1 and 2 separately. 

Jasmine Sexton
No RepliesBe the first to reply