This program is drivin me crazy. I really need some help please. I have created three tables and then a query. The tables are connected in a relationship by the ID. All three tables show a FIRST NAME AND LAST NAME.
I need to know how to set it up so if I change the FIRST NAME OR THE LAST NAME in one table or query that it will change the name in all of the other tables and or query. So that every table has the same ID and the same name.
In other words these are common fields in all tables and the query but when i change it in one it doesn't change in the others.
Does anyone know how I need to set it up so the common field match.
Thank you so much for your time and effort.