Share
ReportHi all,
Please consider the below case and suggest solution.
Master Entity: Consists of information that is consistent i.e. Class students: Name, Age, Address etc.
Child Entity: Consists of Related information i.e. Students information in each semester, Semester 1: Total Marks, subject details, achievements etc.
Sub Child Entity: Consists of related information of Child entity i.e. Marks breakup in each subject for each semester, English: Sem1 : 40, Sem2: 30 etc.
I think I shall create 3 separate entities for this scenario and 3 different forms.
Sub Child can be added as a grid in Child Form
Student name can be a lookup in Child Entity
How the relations between all 3 entities be set
Can I show a report and display all records from 3 entities in one form
*** Most important: How will I be able to import data from a single sheet excel file.
Please suggest if my understanding and plan is correct and if there is anything I shall be knowing for relations between entities, please let me know.
Regards
Deepak Kumar
*This post is locked for comments
All responses (
Answers (
291,280
