How do I create a layout with fields whose data comes from
How do I create a layout with fields that are placed in the layout only to display data that comes from other databases based on searches?
In this case I want to create a web page that lists all students in a each class that would look like this:
Class 1 Class 2
Teacher Joe Teacher John
Tues 8 AM Thurs. 10 AM
Student 1 Student 1
Student 2 Student 2
Student 3 Student 3
The class, teacher and time will each come from a database of all the classes ever offered. The Student 1, Student 2, Student 3 etc. fields will be populated based on searching through an "Attendance" database to see which students signed up to attend that class.