Forum Discussion

evalindag's avatar
evalindag
Frequent Visitor
5 years ago
Solved

Create relationships between two tables through datetable and other table

Hi everybody

 

I'm working with data from many different tables and I'm trying to connect two of the tables through both date and one other field. 

I've added a screenshot here below. So I'm working with the "RetailTransAction" and "Registrations" tables. I've been successful in creating a date relationship between them as I created a seperate "Datetable". Now I'm trying to create a connection between them through the "sta STA_BKV_V_Vidd" table as they both have a field called "DivisionNo" so I want to connect to that table so I get the name of the division and can have only one filter in the report. As it is set up now I have to have two different fields for the Division so my report updates correctly. I've added a screenshot from the report beside the other screenshot where "Dagsetning" is "Date" and "Deild" is "Division"

 

Can somebody help me with how I can create this relationship? 

 

Best regards

Eva

 

  • Hi evalindag ,
    I think you have the inactive relationship here, otherwise there will be a circular relationship outside of the screenshot.

2 Replies

  • mwegener's avatar
    mwegener
    Most Valuable Professional

    Hi evalindag ,
    I think you have the inactive relationship here, otherwise there will be a circular relationship outside of the screenshot.

    • evalindag's avatar
      evalindag
      Frequent Visitor

      Hi mwegener,

      You're right, there was an circluar relationship outside the screenshot

      I've now deleted that and made the other one active and it works 

      Thank you for your help 🙂

       

      Best regards

      Eva