Form Construction

[Shoelaces]

I have constructed a simple discipline database for a principal. This
database has a table of students linked from another database.

There is a table, DisciplineCard, which holds records of various discipline
infractions. The fields are:
autoID
StudentID (from a related table that is linked from another database)
DateofInfraction
Place
Offense
etc.

I created a form to enter the information about the infraction. The
principal types in the StudentID, date, etc.

The desire is now to display the name of the student on the form after the
StudentID is typed to ensure that the correct student is being written about.

I am trying to determine how to do that. The student names are available in
the student table as firstname and lastname.

Any help would be very much appreciated.

 

[Allan Murphy]

Instead of typing in the StudentID, use a combo box to display student id
firstname and lastname

 

[Shoelaces]

Instead of typing in the StudentID, use a combo box to display student id
firstname and lastname

Thank you. Fiddling with that produced the desired result. I appreciate
the help.

 

[Allan Murphy]

Thank you.

This is why these groups exist to share knowledge and offer various
solutions. And it is FREE.