Jump to content
xisto Community
Sign in to follow this  

linking database tables Linking Two Tables

Recommended Posts

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


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.