How to get tblStudent table record data by input studentCode
There are two tables:
tblStudent:
StudentID autonumber
StudentCode Number ; lookup from StudentCode Table
StudentName short Text
StudentAddress short Text
tblStudentCode:
CodeID autonumber
StudentCode short text
Now I want to design a query or form:
get the studentCode from tblStudent, and display studentCode,StudentName, StudentAddress
Please help, I am a new programmer.
Thanks!
There are two tables:
tblStudent:
StudentID autonumber
StudentCode Number ; lookup from StudentCode Table
StudentName short Text
StudentAddress short Text
tblStudentCode:
CodeID autonumber
StudentCode short text
Now I want to design a query or form:
get the studentCode from tblStudent, and display studentCode,StudentName, StudentAddress
Please help, I am a new programmer.
Thanks!
Last edited: