Create relationships between two tables through datetable and other table

[evalindag]

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

[mwegener · Accepted solution]

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

[evalindag]

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