Thanks for looking.
No the table names haven't changed. I did find out the user wasn't entering data in the form correctly. That problem has been resolved
I am still curious as to why the related tables don't show up as related in the be. The relationships show up correctly in the relationship window. And everything else is behaving the way it should (operator errors not withstanding).
Unfortunately I don't have access to the db at home. I retired last week and they won't give me an account to work with. Hmm. They still hope I can fix the db though. I will be in the office next week and can explore a few options then.