Forum Discussion

Maryann's avatar
Maryann
Helper I
6 years ago

Relationships

  Trying to create relationships for a correctional institution system I have charges offense code and hearing result offense code both joined separately to offence code descriptions.  both were c...
Need Help
parry2k's avatar
parry2k
Super User
6 years ago

Maryann it is very hard to see what is going on. what happens when you try to make it active, you probably get a warning message, what is that?

  • Maryann's avatar
    Maryann
    Helper I
    6 years ago

    When I try to make the relationship active this is the message:

    "You can't create an active relationship because an active set of indirect relationships already exists between these two tables.

    To make this relationship active set the cross filter direction to single, delete , or deactivate any of the indirect relationships first."

     

    These are the relationships in question

    1- OIC Incidents <---(active-single)   Staff Members

    2- OIC Incidents --->(active-single)  OIC Incident investiations   <-- (inactive-single)  Staff Members   

     

    3- OIC Incidents --->(active-single)  OIC Incident Charges   <-- (active-single) Offences 

    4- OIC Incidents --->(active-single) OIC hearings --->(active-single) OIC hearing results   <-- (active-single) Offences

     

    Not sure why 4 works and 2 does not work.

    thanks for all your input.