December 4, 200718 yr I need help please, this is driving me mad. I have this issue in many tables that are related. I have a "contacts table" with field Full_Name (A calc to get: Prefix, First name, Last name etc.) and a "schedule table" with field Staff_Name that looks up the values from "Contacts table" Full_Name. Once Staff_Name has been entered in the "Schedule table" (via drop down) if I change the details of that name in the "Contact Table" (spelling for example) how do I get all the records that have that Full_Name in the "Schedule Table" to change to the changed entry? Thanks in advance for the help! Edited December 4, 200718 yr by Guest
Create an account or sign in to comment