Forum Discussion

adrien5555's avatar
adrien5555
Icon for Helper II rankHelper II
10 years ago
Solved

Inactive relationships : When multiple relationships are to be done

Hi all,   All the data must be seen by date, and by location, basically. So based on your good advice, I created a "date" table with all dates, and a "country" table with all countries.    All da...
Need Help
  • konstantinos's avatar
    konstantinos
    10 years ago

    adrien5555You need to make one  of the below relantionship "Single" filter direction istead of "Both".

     

    Dates 1:* BusinessReportAmazom

    or Continents and countries 1: BusinessReportAmazom

     

    The problem if the relation was active then the filters from this table could went through Dates or through Continents table and there is no way the engine to know which should follow so it gives an error.

adrien5555's avatar
adrien5555
Icon for Helper II rankHelper II
10 years ago

Greg_Deckler: Sure :) As you can see below, the 2 tables can already relate to each other thru the "Date" table, which seem to cause the relationship to be deactivated when I create it.

 

 

konstantinos's avatar
konstantinos
Icon for Memorable Member rankMemorable Member
10 years ago

adrien5555You need to make one  of the below relantionship "Single" filter direction istead of "Both".

 

Dates 1:* BusinessReportAmazom

or Continents and countries 1: BusinessReportAmazom

 

The problem if the relation was active then the filters from this table could went through Dates or through Continents table and there is no way the engine to know which should follow so it gives an error.

  • pandiarajan's avatar
    pandiarajan
    Regular Visitor
    9 years ago

    very useful solution thank u very much