Good day to all,
I'm working on data concerning road traffic accidents for a certain period. The attributes (variables) of each data point (each accident) can be found in 5 different tables, and the final table I want to achieve would have each data point (accident ID) together with its variables from all the tables, and to do so I have linked my tables using the relationship shown in the attached screenshot. I have created a bridge table to account for the duplicated values (as each accident has many components such as vehicle 1 and vehicle 2 and therefore the Accident ID would be duplicated in tables) and then using a one-to-many relationship, I linked the tables through the variable "ID_Accidente" and the join type I chose was "Include ALL records from 'Table Name' and only those records from 'BridgeTable'(which contains the non duplicated accidents ID's) where the joined fields are equal, but what I keep getting in the query is only the accidents ID's for which there is a value in each row (for example, not all accidents include pedestrians so data points with no pedestrians won't show in the final query). Can anyone suggest a solution so I can show each accident ID with all the attributes from all the tables?
Thank you in advance!