I have three tables that all need to be connected, however this creates an ambiguous relationship between the tables. I understand why that happens. However, I cannot think of the solution to my problem of connecting all three tables.