I believe there are problems in database design.
In the tblCaseAjourn table the periods Dates_1, etc ... are fixed or could a Dates_6 field be added?
Because if this were the case you need to normalize the database:tblCaseAjourn
Inm_pd
Case_pd
CaseNo
Notes
tblCaseAjournDates
CaseAjID
At your place
also for each date Case_pd always remains the same or can it change?
Because if the Case_pd field from the tblCaseAjourn table changes it must be moved to the tblCaseAjournDates table.
The same consideration applies to CaseNo.
Furthermore, you must learn to correctly set the properties of the various fields in the tables, especially:Field size, for Text-type fields
Request
Indexed, especially Duplicates not allowed to avoid duplication
Furthermore, I believe that the relationships are not exactly correct because, not knowing how the whole process is managed, I believe that some tables should not be related to tblInmates but to tblCaseAjourn.
For this last reason you should explain the whole process in detail for example:the subject enters for a reason
during this period he may have exit permits
the detention period ends
come back for another reason
during this period he may have exit permits
the detention period ends
I apologize if what I wrote could be difficult to understand as being Italian and not knowing English well I resorted to the Google translator.