Here is our case:
We’ve a community layer and a projects table. Each community have several types of projects and a community can have several projects of the same type. We need to apply symbology for all projects types implemented in a community including those of the same type. Please note that the community feature class and the projects table should keep separated and not merged in one layer as editing should be made only on the projects table.
What do you think?
Please check the screenshot below for more clarification.