linking database tables Linking Two Tables

[iGuest 3]

linking database tablesLinking Two Tables

I have createtwo tables in ms access.The table names are student and qualification 

In the student table primary key is SmartCardNo and the qualification table primary key is combination with SmartCardNo and Class. This database I linked with the vb.Net and I want to search the data from the database and appear in text boxes. When I enter the data in to the database tables by using INSERT INTO Statement  it s wotking fine.But when I search the data by using SELECT  statement its showing error.I think the  problem is in the student table only once I'm enter the smart card no but in the qalification table I have enter the smart card no more than one time because one student can have more than one qualification but his or her samrt card no wont be change.

please help me to solve this problem.

thanks in advance

-question by malar