Help with Relookup Field Contents

[Carri]

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, 2007 by Guest