How do I create a relationship between two tables with the three matching columns. (1 to 2 ratio)

malex30 what you need to do is unpivot the audit table, select all the columns except the day, and night columns, right-click, and unpivot other columns. You will get two columns, attribute and value. Rename attribute to Shift and Value to Id. close and apply.

Now you have one relationship with the Contact table, visualize the way you want and if you want, you can filter on the Shift column to get only day or night.