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.
- I feel honored that you returned on my behalf :) That definitely helped me with #2 on my list! Thank you so much!
I would still like to figure out how to pull the permit statuses onto the construction record. - OK. I am in the car now so this is really Siri talking. So given that there is a maximum of 10 and while Matthew won't like this approach, it can be done with 10 verse relationships. I have one more question before I explain the technique. Is there typically only one permit per trade. I.e. is there only one electrical permit and one plumbing permit. Or are they kind of random and you could have more than one electrical permit. I am just trying to think of when these fields are rolled up to the parent whether they can have nice field names or and be in a consistent sequence.
- 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.
