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
This is definitely a Many to Many situation. i have a home reno going on now and its needs permits, so I can picture the situation.
I would call the middle table Project Permits.
One Project has many Permits.
But I gather that maybe 1 permit has many Projects, say a whole row of houses or condos going up and they are all under the same electrical permit.
One you set up that middle table and the two relationships, you will be able to show an embedded report of the Project Permits on both the Projects Record Form and the Permits form.
Post back once you get that set up. If you need some summary fields like permit dates or Permit numbers floated up to a Parent record, there are ways to do that.
I would call the middle table Project Permits.
One Project has many Permits.
But I gather that maybe 1 permit has many Projects, say a whole row of houses or condos going up and they are all under the same electrical permit.
One you set up that middle table and the two relationships, you will be able to show an embedded report of the Project Permits on both the Projects Record Form and the Permits form.
Post back once you get that set up. If you need some summary fields like permit dates or Permit numbers floated up to a Parent record, there are ways to do that.