Forum Discussion
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.