I created this database to record inmates visits and letters to friends and family. This is the process the inmates fills a form (visit form) which is sent to a department which enters the data in the database. the form contains the name of the inmate and his or her contact and invitees.
therefore a visit form will have on the contact person in which the visit is posted to and it contains up to 3 invitees (invitees persons who can accompany the contact on day of visit)
The database has been serving its purpose until I was asked to accomodate the department in the contact calls to make the appointment for the visit.
I was thinking I would create another table called appointments which will contain appt time, appt date, contact name and invitee name but I am experienceing problems with the population of the above.
Attached is a sample of the database with test data
Any help and comments would be appreciated