MasterTable got three column (ID, AwardName)
MemberTable got three column (ID, Name, Stage)
I want to display the AwardName and Stage where Name = Dropdownlist value.
The problem is AwardName that the member achieved comes with their various Stage...
So the output shoule be something like this when a ddl value is autopostback:
AwardName Stage
----- --
XXXXXXX Advanced
CCCCCC Basic
How do I get the stage to match with the AwardName in the same Row... ?What is the relationship between the two tables? Is there a FOREIGN KEY here? If so, specify.|||The MasterTable store all the awards info: Awards ID, Awards Name
The MemberTable store the achivement of member...the awards that they have achieved: Awards ID, Members ID, Stage
Stage have 2 values, Basic and Advanced...
So everytime a member received an award...it will store in MemberTable. Example, if a member achieved an Award with the Awards ID "01" and the stage is "Advanced"
It will store in MemberTable as one record :
MemberTable
AID MID Stage
-- -- --
01 xxx Advanced
So now I want to display all result achived by particular member... i want to display the Stage and the Awards Name
I never use foreign key...|||I have got the SQL Statement...
Thanks
No comments:
Post a Comment