At the outset, I feel it's a privilege for a novice Access learner like me to get valuable advice from this esteemed Forum.
I need help in resolving the following issue(s) in my contacts database management:
I have created a contacts database in Access 2016 for my company. All tables l are in a one-to-many relationship joined by a primary key from each table:
- TblOrganizationType (Eg., Education; Health; Government etc.)
- TblOrganizations (Eg., Xyz University; Ministry of Health, Medical Colleges etc.)
- TblInstitutions (Eg., College of Medicine; College of Science, Research Council etc.)
- TblDepartments (Eg., Department of Psychology; Department of Research etc.)
- TblSections (Eg., Medication education Section; Communication Section; Housing Section; Transport Section etc.)
- TblEmployeeContactInfo (Eg., Title, FirstName, LastName, Position, Tel Ext., Mobile1, Mobile2, Email1, Email2 etc.)
My queries:
- Although TblSections is linked with TblDepartments, some Departments, in fact, do NOT have any Sections under them, as per our organizational structure.
- Secondly, TblSections is linked with TblEmployeeContactInfo. Therefore, when I run a query based on all the above tables, the output doesn’t retrieve all the data as some departments have no sections under them, but still have employees linked with some of these departments.
- What I need is to be able to design appropriate forms to input the data into the tables; and the query or report should retrieve all related data of all employeeContacts irrespective of some departments having no section(s) under them, while some other departments have related sections under the specific departments.
Will appreciate any suggestions to correct my database design to suit my needs.
Kind regards,
Sagar