AnsweredAssumed Answered

Display records from one table in another table/layout?

Question asked by iMakeFilez on Nov 17, 2011
Latest reply on Nov 18, 2011 by philmodjunk

Title

Display records from one table in another table/layout?

Post

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#.

Outcomes