Skip to main content ↑ ↓
Topic: Master Child Records (Read 340 times) previous topic - next topic

Master Child Records

I have created below tables:
TableName: StudentData
Filed Names:
StudentID (AUTO INT)
FullName
MobileNumber
EmailID
Address

TableName: Grades
Filed Names:
GradeID (AUTO INT)
StudentID (INT)
MathGrade
PhysicsGrade
ScienceGrade

StudentData table is my Master table and Grades is my child table. I have set relation on StudentID field. I am able to add record in StudentData table but when I add data in Grades table using relation the StudentID field of Grades automatically appears 0 and it does not shows under StudentData table as child record

Please help

Re: Master Child Records

Reply #1 –
@STEVENDISHA‍ from your description you made grades the Master table in the Master-Details Relationship. From your table structure Master table, and with that you cannot add a master record from a details table. But you can add a details record from a master table.