It would be good to get the database relationship diagram sketched out so missing pieces stand out.