Need Help....

I got two table MasterTable and MemberTable

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