I got the dropdown to show the fullname but I can't see to populate the rest of the fields with their data.. depending what it was selected.
" The other table/layout, I want to have..."
Which is the name of that other table? How is it related to the Teachers table?
Ok, I did linked the table by Teacher ID:
Teacher:: teacherID --- Report::ReportID
On the Teacher table, I have the following as fields: teacherID, Fullname, email, and subject... Which I added all the information to the fields
I have 8 records on the teacher table.
On the Report table, I have the same fields. The relationship between the two table is link by teacherID and ReportID..
On the Report Layout.. I have a dropdown list for user to select teacher which it does gives me all the teachers name. Then I am having a problem for the other field to populate the field once I select a teacher. The teacher::email for record 1 show me whatever is on that field, but on report:email is blank.
See image below.. I will fix the fullname field to show the teacher name instead of the ID. I still having trouble for the REPORT fields to fill up once I select an ID from the drop down..
The link that you recommended I did tried it out but does not show how the other fields fill up..
With that relationship, you don't need the fields in Report for email and subject. Just add the email and subject fields from Teacher to your Report layout. That is one of the two methods described in the thread that I recommended.