How to updated all the releated records.

See more:

C#3.5

SQL-Server-2008R2

Hi guys,

I have one scenario, where i have to updated ceritificate records.

for eg:
candidate is registered for C1.
And from C1 he can upgrade to C2.
And from C1 or C2, he can upgrade to C3.

so, in database table i have CertificateID, and added one morecolumn for, UpgradeToCertificateID.

its looks like, this:

What I have tried:

-----------------------------------------------------
CandidateID | CertificatID | UpgradeToCertificatedID |
-----------------------------------------------------
     9      |   c1         |   null                  |
-----------------------------------------------------
     9      |   c2         |  c1                     |
-----------------------------------------------------
     9      |   c3         |  c2                     |
-----------------------------------------------------

Every certificate have some modules. And I have separate table for modules.

Now, if i update modules in c1, i want to update c2 and c3 modules,
or if i update modules in c2, i want to update c1 and c3 modules,
or if i update modules in c3, i want to update c1 and c2 modules.

can any one please help me, how can i do...

plz give your suggestions/help.


Thanks