Display records from one table in another table/layout?
I have 1 database with 2 tables inside, Members and Students. The Members table has fields such as Name, ID#, Age, etc., and the Students table has a Grade field as a dropdown list. I want to set up a Student layout so that it can show me data from the Members table, such as Names, ID, Age, and the dropdown list for the Grades from the Students table. So far I've been able to get the Grades field to show me the data in the dropdown list, but am unable to get the Name, ID, Age, etc. to show up. I set up the table so that they are linked together via the Serial#.