Related tables and fields
I am creating related tables. I need to be able to narrow the records that can be chosen after a particular field is chosen. Example: I choose which student I want to use. After I choose the student I want the course drop down menu to be limited to the Courses the selected student is enrolled in instead of all of the courses in the course table.