input a field from a table and get all information from another table

[Unixaix]

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!

 

[theDBguy]

Hi. Will this work?

SELECT * FROM tblStudent WHERE StudentCode=[Enter Student Code]

 

[Unixaix]

Hi. Will this work?

SELECT * FROM tblStudent WHERE StudentCode=[Enter Student Code]

What I want to do is:
use lookup display studentCode, then I select a StudentCode,
and get the match student information and display in the screen.

 

[Unixaix]

Hi. Will this work?

SELECT * FROM tblStudent WHERE StudentCode=[Enter Student Code]

What I want to do is:
use lookup display studentCode, then I select a StudentCode,
and get the match student information and display in the screen.

 

[theDBguy]

What I want to do is:
use lookup display studentCode, then I select a StudentCode,
and get the match student information and display in the screen.

Hi. There's a lot of ways to do this. I am not sure what you have in mind. You could take a look at some demos and see if there's one you could use or post a mockup image, so we can help guide you on how to build it.