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 parent can have multiple children and each child can have multiple parents.
The way I have it setup in Quick Base, I use a related proxy field to select my parent on the child record. What I need to be able to do is select multiple parents at one time. So Child Record 1 might have Parent Record 2, Parent Record 3, and Parent Record 4. Parent Record 2 might have Child Record 1, Child Record 2, Child Record 3, and Child Record 4.
I've seen that I can set up a many-to-many relationship with a third table but I'm not sure if that's what will solve my problem. I need to be able to do lookups/summaries between the parents/children and I need it to be user friendly.
I don't know coding, so if coding is required, I will need detailed steps. Thank you in advance!
The way I have it setup in Quick Base, I use a related proxy field to select my parent on the child record. What I need to be able to do is select multiple parents at one time. So Child Record 1 might have Parent Record 2, Parent Record 3, and Parent Record 4. Parent Record 2 might have Child Record 1, Child Record 2, Child Record 3, and Child Record 4.
I've seen that I can set up a many-to-many relationship with a third table but I'm not sure if that's what will solve my problem. I need to be able to do lookups/summaries between the parents/children and I need it to be user friendly.
I don't know coding, so if coding is required, I will need detailed steps. Thank you in advance!
