Crisis and Home Treatment is an Access Project (ADP) which is a front end to Microsoft SQL Server.
In Access jet database you rend to go into a form which is already populated with data and use the access filter options to limited the records you view/modify.
When working with SQL as the data storage you need to limit the number of records requested. Therefore we start with a search form which is unbound and therefore making no requests to SQL Server.
You can search by name and address, abbreviating where necessary. In the example below have used Rush instead of Rushforth and Col instead of Colin
You could do a separate search by telephone number or by DOB. Click on the appropriate search button.
From 6500 people SQL Server has only sent the two you requested.
You can double click on the ID number to get the person's details.
Among the details of the person is the number of Referrals, Assessments, Follow-ups and scanned documents. The scanner software is loaded from the database, the document scanned in PDF format and attached to the database with a file name so that it can be viewed at a later date.
These assessments can be viewed and a new Assessment created if necessary. Click on the appropriate view button.
You can double click on the assessment ID to view the assessment, or click on the New Assessment button to create a new one. When you create a new assessment some of the information is copied from the old assessment to speed up the creation of the document. After 2 days the document is locked so that updates cannot be carried out after the event.
There is an automated routine with the Assessments, Referrals and Follow-ups to change the assessment into a PDF file, create a cover sheet, EMail the information to a Fax company who Fax the document to the appropriate place. An Email is returned to say whether the Fax was successful or not.