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.
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.