I've used the following query builder to build the following form. Getting the records to update has been a brick wall. The fields that are located in the table:Record Class Codes update just fine, they are standalone bits of information. It's when the form is pulling the information from another table that I am having difficulty with the update. I would need the table:Record Class Codes to update the references (foreign Keys) for any change that took place. I don't see that Access has this dummy-proof capability. am I wrong? How should I approach this pretty obvious issue?