1. First, the relationship between student information table and class table is established through student information, class and class. ID (or you can not establish the relationship first, and then establish the relationship when the query mentioned below is created); Create another query, which can include the ID of the student information table, the name of the class table and the class field (the class ID may not be included, so it is unnecessary for the user to appear), and finally modify the properties of the split form you created >; The data > record source is this query, so the fields you need will appear in the form.
2. The form you have established remains unchanged. Add an unbound text box, and set the control source of this text box =DLookUp("[ class], "class", "[class]! [ID]=[ class]"。 (Because "class" appears too many times, you may need to explain the function. The DLookUp function will return the value of the corresponding field in the table that meets the conditions. The first parameter is the field name of the obtained value, the second parameter is the table name, and the third parameter is the condition; The 1 th "class" represents the class in the class table, the second "class" represents the nominal class, and the third "class" represents the nominal class. [class]! [ID] is used to represent the ID field in the class table, and the fourth "class" represents the name of the class text box on your form, provided that "[class]! [ID]=[ Class] "indicates that the ID of the category table should be equal to the value of the category text box on the form. For more information, please refer to the help in access)