Alright I have fixed the missing table problem that I somehow had yesterday.

The only problem I have now is that while running the database, the new field in the tables won't update. The local view is called facility. The table is called fac_mas. The program is linked to facility. I noticed in the View Designer in the Update Criteria, the only field that won't let me click it as a key field is my new field. I'm assuming that my problem is directly related to this. None of the other fields are checked as key fields either, but there is obviously a difference between my new field and the others.