Forum Discussion

Qrew Trainee

8 months ago

Many to Many too Many...

I've searched through the QB discussions and couldn't find a good example of creating a many to many relationship where I can select records from the same table. I have the relationship working from ...

Relationships

ReneeHansen1
8 months ago
Hi!
So I think what you'll need is (what I learned to call it) a "Join" table. In order to create a many-to-many, you are not having it go from one to the other and vice versa.
You have a table in between that one goes into and then the other goes into, so the "Join" table is the "child" of Table A (Parent Table), and a "child" of Table B (Parent Table).
Then you'll have the related field from parent table A, and the Related field from Parent table B on your form, or reports, and you can select data from each and have it "joined" together in one table.

Hope that helps!

ReneeHansen1

Qrew Cadet

Hi!
So I think what you'll need is (what I learned to call it) a "Join" table. In order to create a many-to-many, you are not having it go from one to the other and vice versa.
You have a table in between that one goes into and then the other goes into, so the "Join" table is the "child" of Table A (Parent Table), and a "child" of Table B (Parent Table).
Then you'll have the related field from parent table A, and the Related field from Parent table B on your form, or reports, and you can select data from each and have it "joined" together in one table.

Hope that helps!

GlennHopkins

Qrew Trainee

7 months ago

Thanks Renee! That's pretty much what I ended up doing. I created 2 new fields that referenced the "Record ID" of each guest (using formula - numeric). Then I used those to build my "join" table while referencing the new fields. It ended up with exactly what I needed. I'll mark your response as the solution. Thanks again!