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