I have been handed someones work and asked to complete it along with make a few enhancements...
What I need help on is the following
The original table that was created has users where an email is sent to, and 9 approval status's
If approver 3, 6 and 7 have an e-mail address that is @myficticiousaddress.com and the rest have @haveityourwar.com is there a way that I can run some SQL from the ASP.Net \ VB.Net Application to say
if, approver3 = approved then approver6 and 7 also = approved.
if approver 6 = approved then approver 3 and 7 also = approved,
One issue I can foresee with doing this is when an approver is removed or added, it will need to look through all 9 approvers for the e-mail addresses to see if the email address is like @myficticiousaddress.com
I would have liked to have done this differently however this was handed over 95% complete and 80% rubbish..
Any and all help, as always very much appreciated.