Union Query ... Is this right?

  • Thread starter Thread starter Susanne
  • Start date Start date
S

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.
 
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!!
 
Back
Top