Multiple Children with Multiple Parents
I've been searching for an answering but I can't find exactly what I need so I'm hoping someone can help walk me through this. I have [Construction Projects] (Parent) and [Permits] (children), each pa...
Forum Discussion
Alright, after taking a hiatus from the community. I've decided to come back and prevent the creation on unnecessary reverse relationships.
Now that you have a joined table, you can build the report on the joined table, and just group by the project, then you can see any and all the details of the project or permit you need to.
Now that you have a joined table, you can build the report on the joined table, and just group by the project, then you can see any and all the details of the project or permit you need to.
You're devoted, I like it! All of the permits are for underground work. The only thing that differentiates the permits are the permit numbers. I have another table setup for aerial permits. So whatever I end up doing to the permit table, I'm going to replicate on the aerial permit table. Hope this all makes sense.