How to keep two fields in sync with one another?

Question

Post reply

How to keep two fields in sync with one another?

ttabol-1064985

Grasshopper

Points: 17
More actions
May 29, 2013 at 5:12 pm

#293932

Hello All!
Here's my conundrum...First off, the PK is IDNUMBER. I have a table, let's call it AL with an Email column, the AL table can be updated from a form that specific users have access to. Then there is another table, let's call it AD with a column for Address1 and a "qualifier" column AddressType. The AD table can be updated from a different form that different users have access to. I need to be able to update AL.Email when someone makes a change to AD.Address1 WHERE AddressType = 'Email'...AND...I need to be able to update AD.Address1 WHERE AddressType = 'Email' when someone makes a change to AL.Email. I have created triggers which will work one of the two ways but if I enable both, they compete and will not allow the data to be saved. I'm guessing that it is something simple that I am missing but I just can't wrap my head around it today. Anyone out there have any good ideas? Sample code is great if you care to share! I'm sure someone out there is doing this exact thing! Thanks in advance!
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 1

I'm... confused I think.

Can you list out your schema and some sample data in a consumable format, along with the triggers you've built so far? It would be far easier to follow what you're trying to do.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

mister.magoo SSC-Forever Points: 47174 More actions · Answer 2

It sounds like you are getting in a bit of a loop...

Take a look at this MSDN page.

Once you understand that, put an IF in your triggers to only fire for nest level 1 to prevent the looping.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);