The Reverse Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database of Issues being worked. One table lists related issues. My form allows you to pull down the exisiting issues and select the related Issue. What i'm trying to do is to create a record to show the backward relationship

new Record 1 -> 2 one is related to two Would also create 2->1 Two is related to one record

Seems simple most likely, is I just can get there
 
JimBob

If you have Issues, and relationships between Issues, I suspect you only
need one "Issues" table, and one table to hold "Issues-Related-to-Issues"
information. That second table could be as simple as two columns ... one
holds an IssueID, and the second holds ... the related IssueID! With that
second table, you can write queries from the first column to the second or
vice versa.

Or have I misunderstood your situation?
 
No, I've been thinking that this could work also, but haven't come up with a way.

The current approach was a table with three columns the first which is used to locate the data is the primary issue ID the second colunm is the related Issue ID the third column is how the relationships work. (Primary Issue needs to need resoved before the Related, the Related needs to be resolved first, The two are mutually exclusive and I need to pursue one and not the other and finally that both must be implemented togeher).

The Main Issue form dispalys a subform that lists all of the related issues. If I could use either column to find related issues and display them this would work. I just don't know how to make my display work using either column from the table.

Jim
 
Back
Top