|
Im a college student, my program is a computerized enrollment system, Im using MS ACCESS database in connecting my VB6 program form. Inside i'd created two tables, named "tbstudentinfo" and "tbstudentfees". In my 1st table i renamed my fieldname to STUDENTNUMBER and STUDENTNAME on the second fieldname, then below i entered (0001) for studnumber and (Paul) for studname. The 2nd table is almost the same with the 1st table but i added another fieldname (STUDFEES) and entered 5000 below. But my problem is on how to connect the 1st table to the 2nd table, i mean in the 1st table i entered the student number and the name of the person who enrolled. Then in the 2nd table, student payment or fees i need only to type the student number "like a search engine" and it will automatically shows the name that i'd entered in my 1st table and that will show in my VB6 program form running mode then saved it in my database. So i need a simple sample code or a whole simple code or a sample related to this system that i can understand definitely the code. Before i forget im currrently using ADODC database MS ACCESS connection. I hope you understand my problem and share your precious knowledge to someone really need it the most, to become successful someday in programming and i promised that GOD will bless you, not once but twice. And Thanks in advance to those who read and post their helpful codes, from the bottom of my heart.
if you have a simple way like using MODULE just give a code that can easily understand x) cause i dont know how to use MODULE in connecting 2 tables in a single database.
| 
