Hey, Kevin,
I can't say for certain, but a couple of things...
You have several tables with recordid that aren't linked, and several that are. Is that for a reason?
How are the joins defined? Do all of the child tables contain at least one row for the parent?
Kevin