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