Hi.
Although I am not new to Access, I feel I need help in resolving the following issue.
I have created a contacts database. Following tables are in a one-to-many relationship in the following hierarchy (primary key from each table with its counterpart foreign key in the linked table):
1. TblOrganizationType (Eg., Education; Health; Government etc.)
2. TblOrganizations (Eg., Xyz University; Ministry of Health etc.)
3. TblInstitutions (Eg., College of Medicine; College of Science, Research Council etc.)
4. TblDepartments (Eg., Department of Psychology; Department of Research etc.)
5. TblSections (Eg., Medication education Section; Communication Section; Housing Section; Transport Section etc.)
6. TblEmployeeContactInfo (Eg., Title, FirstName, MiddleName, FamilyName, Position, Tel. Ext., Mobile1, Mobile2, Email1, Email2)
A. Although TblSections is linked with TblDepartments, all Departments may not have any Sections at all, and therefore, the Tbl5Sections may not have data in it; however, the Tbl5Sections is linked with Tbl6EmployeeContactInfo. Here is the main issue: when I run a query based on the above tables, the departments that have no sections under them, are not being retrieved.
B. Just a suggestion: Please advise if a JunctionTable (Many-to-Many relation table) will help as a link table between: TblDepartments and TblSections, so that my query output or report output can show all related data of an employee from a Department having a Section or no Section under it.
C. Will appreciate any other suggestions useful in improving the whole design and structure of the database.
I hope I have presented the scenario clearly.
Thank you in anticipation.
Although I am not new to Access, I feel I need help in resolving the following issue.
I have created a contacts database. Following tables are in a one-to-many relationship in the following hierarchy (primary key from each table with its counterpart foreign key in the linked table):
1. TblOrganizationType (Eg., Education; Health; Government etc.)
2. TblOrganizations (Eg., Xyz University; Ministry of Health etc.)
3. TblInstitutions (Eg., College of Medicine; College of Science, Research Council etc.)
4. TblDepartments (Eg., Department of Psychology; Department of Research etc.)
5. TblSections (Eg., Medication education Section; Communication Section; Housing Section; Transport Section etc.)
6. TblEmployeeContactInfo (Eg., Title, FirstName, MiddleName, FamilyName, Position, Tel. Ext., Mobile1, Mobile2, Email1, Email2)
A. Although TblSections is linked with TblDepartments, all Departments may not have any Sections at all, and therefore, the Tbl5Sections may not have data in it; however, the Tbl5Sections is linked with Tbl6EmployeeContactInfo. Here is the main issue: when I run a query based on the above tables, the departments that have no sections under them, are not being retrieved.
B. Just a suggestion: Please advise if a JunctionTable (Many-to-Many relation table) will help as a link table between: TblDepartments and TblSections, so that my query output or report output can show all related data of an employee from a Department having a Section or no Section under it.
C. Will appreciate any other suggestions useful in improving the whole design and structure of the database.
I hope I have presented the scenario clearly.
Thank you in anticipation.