I am NB to access, I know enough to create forms and tables. But could not wrap my head around creating a relationships between tables.
I am in the process of creating a database for a school in remote place in India (for free of-course)
Once a student enters school he/she spends about 10 years advancing each year.
I created
1. table for student info
2. table for various subjects
3. table with teacher info
4. table with academic year.
4. table for class
each student would be advancing into a new class every year. I could not come up with a relationship to capture this without duplicating the data.
I would appreciate your help in this regard
Kumud