Hi
I am new to Access
I am trying to make a database for the school. I have created 3 tables
Student table with 3 fields as – (a) [ID] as primary Key (b) First Name (c) Level
SubjectCatagory Table with 2 fields as (a) [ID] as primary Key (b) CategoryName
Subjects Table with 2 fields as (a) [ID] as primary Key (b) as Subject Name
There are 4 subject categories (a) Science (b) Arts (c) Commerce and (d) Humanities
There are 9 subjects in each Subject Category and the student has to select 5 subjects from the concerned category
e.g. Student A is a Science Category student, he will chose 5 subjects from science category.
Likewsie Student B is a commerce student he will chose 5 subjects from commerce category. And So on
The problem is that when the student seeks admission in the school computer should allot the concerned subjects to him if he selects any subject category.
How can I solve it.
Please help me
Thanks
Jalal