I have a situation where I need to keep a number of key data items in
sync within the one file.

There is an existing trigger program over the file which I'd like to see
if I can use to solve my problem.

Ok here goes, we can have the same member on our main membership file
many times. We are going thro' an exercise to link these accounts. Once
linked I need to keep items such as name, address details in sync across
all accounts. Because of the existence of the trigger program I thought
I could maybe use this to avoid having to scroll through our system
looking for places where these items are updated.

Member file Trg1 Member
link - Member file
Update member's address - Trigger called - Linked member
found - Need to update Member address of linked Member (this
will execute Trg1 and therefore crashes)

Can anybody advise

Stephen Brown
Analyst Programmer
CIGNA European Technology Group
1 Knowe Road
United Kingdom
PA15 4RJ
Phone : +44 (0)1475 492274
Fax : +44 (0)1475 730385
E-Mail : Stephen.Brown@xxxxxxxxx

Confidential, unpublished property of CIGNA Do not duplicate or
distribute. Use and distribution is limited solely to authorised
(c) Copyright 2008 (CIGNA Corporation)

CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright 2008 CIGNA

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].