JasmineSexton
4 years agoQrew Member
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.
THANKS!!
------------------------------
Jasmine Sexton
------------------------------
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.
THANKS!!
------------------------------
Jasmine Sexton
------------------------------