I have an Access database with four related tables.
Tables: Students, Teachers, Incidents, and IncidentDetails.
I have one-to-many relationship from TeacherID to Incident table's teacherID
field. A one-to-many relationship from StudentID to IncidentDetail table's
StudentID. The IncidentDetail table has a dual key field of IncidentID and
Student ID. The IncidentID field is one-to-many to the IncidentID field of the
IncidentDetail table.

I would like to be able to pull up by student the incidents they have been
involved with on my palm. And also, enter incidents while away from my desk.

I get lost as to how to accomplish this task.

I have all four tables sync onto my smartlisttogo. How do I make it Join or
Lookup what I want?

This would have great applications to educators!

HELP will be greatly appreciated!