Forum Discussion

Justair07's avatar
Justair07
Icon for Resolver I rankResolver I
7 years ago
Solved

Create multiple relationships from Date table to multple tables

Hello,

 

I have a Date table that I use to filter and toggle between selected dates. I also have a table of the data tha I display, 2019ScrapData. 2019ScrapData has a Date column that I relate back to my Date table. Easy. Now I have another table called qryCellGoals. This also has a date column. I want to relate the qryCellGoals date column to my Date table so the qryCellGoals changes in sync with the 2019ScrapData when a specific date range is selected. Here is the error I'm getting. What am I doing wrong and how can I fix this?

 

 

Thank you so much!

Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Justair07 you have multiple things going on, many to many relationship (* on both side of the relaionship) and also showing two arrows in the relationship diagram shows if cross filter is "both" or not. You want to avoid cross filter to both for performance.

     

     

5 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    Justair07 seems like you have cross filter set to both for one relationship. Can you share relationship diagram?

    • Justair07's avatar
      Justair07
      Icon for Resolver I rankResolver I
      7 years ago

      parry2k here is the diagram. Not sure what a cross filter is. Thank you for your reply.

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        7 years ago

        Justair07 you have multiple things going on, many to many relationship (* on both side of the relaionship) and also showing two arrows in the relationship diagram shows if cross filter is "both" or not. You want to avoid cross filter to both for performance.