Thank you Jason I'll give that a whirl
Lee
Jason L. DeLooze wrote:
Charlene,
Set the Auto-Enter option of the EID field (in the related record) to "Prevent modification of value
during data entry". You may need to also enable the "Data" option (leaving the optional value
empty) so that the "Prevent modification ..." option is not dimmed. This will prevent the Users
from manually altering the EID value in the related record; that is, they won't be able to break the link, as
you reported they were doing.
Regards,
Jason L. DeLooze
Annapolis, MD USA
At 11:45 AM -0600 3/8/07, Flora, Charlene wrote:
Lee,
This can happen if someone has changed the related field data in the
original record.
I have this problem with staff changing the EID field of the original
table and then contact me that the related table has fields missing
data. All I did was enter the original EID field's data into the related
table's EID field which called up the missing data.
Charlene
--