I have a database that I inherited and it has the relationships below. I have not dealt with relationships much and I am not sure if this is the correct way to set it up. It is working but every so often if the ID on one of the tables doesn't match the rest it will make entries disappear from the query. The identity table has many different entries but all the other tables will only have one entry per the ID on the identity table. Hopefully I explained that correctly and it makes sense. Does someone have advice on how this can be setup correctly.