Colin, if you show us tables definitions without attributes out of
question but with PK/FK constraints and all indexes, we can help you
faster.

Best regards, Alexander V.Nevsky.