Union Query ... Is this right?

[Susanne]

I'm going to try this again, maybe hopefully, I'm heading in the right
direction.

I have 2 tables, one with Action Items ane the other with all related Action
Items. Each AI can be related to more than one other AI.

So,
Tables are:
tbl_AI
tbl_AIRelated

tbl_AI has following fields:
AI_PK
AI_Description
AI_Date
....

tbl_AIRelated has:
AI_FK
AI_RelatedPK

Everything works up to related one Action Item to others. My problem is
that I need to then see the relations in the "related" AIs.

That is:
AI_1 is related to AI_3, AI_5, AI_10
so, when I look at the other AIs I need the following to appear (in the
subform):
AI_3 related to AI_1, AI_5, AI_10
AI_5 related to AI_1, AI_3, AI_10
etc.

Any suggestions? Tried going route of the union query, never used it
before, and not sure I'm going in the right direction.

 

[Susanne]

Here I am responding to myself! Well, I figured out part of it, and need
help with the other part. I got the union query and forms to all work. The
issue is related the additional AIs.

I have it where AI_1 is related to AI_2, AI_3
So, with the union query, I get
AI_2 related to AI_1
AI_3 related to AI_1

How about getting AI_2 related to AI_3 and vice-versa? Is this getting too
complicated? I just see it getting really complex especially if you have
(say) 10 AIs related to one. Then, the db would have to somehow figure to
relate each with another.

Thanks!!