Cross-Reference

[Matt_]

Hi there,

I apologize in advance, I have a feeling that this is going to be ridiculously easy to do, but I can't seem to make the relationship work to do this.

I'm creating a solution where police reports are entered, once a report is entered, an officer may want to cross-reference a report to another. It could be more than one report.

ie.

Officer A enters Report #1 for Robbery

Officer B enters Report #2 for Vehicle Theft

Officer C enters Report #3 for Abandoned Vehicle

It is determined that all 3 reports are related (vehicle is stolen, bad guy robs a bank, and then abandons the car). If a user views any of the 3 reports, it should show the 2 other related reports.

I did a search, and didn't come up with anything... any help would be greatly appreciated. Thanks in advance.

Edited October 21, 2010 by Guest

[comment]

I assume that if:

• it is determined that Report #1 is related to Report #2;

• it is determined (at another time) that Report #3 is related to Report #2;

then Report #1 should also be related to Report #3, and the three relationships should be on the same level (not cascading as in parent-child-grandchild).

If so, I would look for a parent table to make these reports siblings. Although the relationships part of this is dead simple, building the user interface is not (as always when parents are created after children).

---

There is also the question whether it should be possible to link Report #3 to Report #4 - without linking the other two reports as well.

Edited October 21, 2010 by Guest