Getting IDs When Need Titles

I created a db and made it back end. I added the another db and linked some tables into it. Everything works fine except that the title and department are showing up as the id instead of name in my employee details form. It is really confusing because it seems as if it is reading the info from the employees extended which shows the names but then puts in the id's.

I believe that location will do the same thing but it hasn't been added to the details form yet. I am sure whatever is the problem with the other ones will also resolve that one.

I have attached the be and the fe : Test.zip test_be.zip