Hello
I am not a programmer by any means. I created my database for use in my private business to keep track of client interactions. I am a social worker that sees clients and I need to record my case notes. I have been using the database I created for about 4 years - but I think there is a better way to handle one part of it.
The database has several main tables (Client Demographics (which has the Client ID as the primary key), Social Service Assessment, Functional Assessment, Equipment Used, Goals, Self-Evaluation, and Case Notes. The problem is with the Case Notes.) All of the tables except Client Demographics has an ID field which is not a primary key.
I have all of the tables in a relationship with the Client Demographics table. Example - when I open the Social Service Assessment from the Client Demographics - the ID of the client I am working with opens in the Social Service Assessment. These ID’s are in a relationship that says – Include ALL records from Client Demographics and only those records from Case Notes where the joined fields are equal.
The Case Note table has the Case Note ID, Date, Time, and Note. Now the table has Case Note 1 with all the fields, Case Note 2 with all the fields, through Case Note 6. When I open Johnny's case notes - and enter 6 notes - then I have to delete and start again – meaning I have top print out the first 6 before I can start with the next 6 notes for that one client.
Now – how do I have unlimited Case Notes for only 1 Client ID. Example – Johnny is the client and each time I see Johnny I make a case note. This may be ongoing for several years. How do I keep all of those notes with Johnny’s ID number and then have other clients with their respective ID numbers and all of their case notes?
This is probably really simple - but I just can not figure it out. I have made it work by printing out the old notes and starting over - but would like to keep all of the notes for each client in the database.
Again - I am in no way a programmer - just found that Access makes my documentation easier. Any help will be appreciated.
I am not a programmer by any means. I created my database for use in my private business to keep track of client interactions. I am a social worker that sees clients and I need to record my case notes. I have been using the database I created for about 4 years - but I think there is a better way to handle one part of it.
The database has several main tables (Client Demographics (which has the Client ID as the primary key), Social Service Assessment, Functional Assessment, Equipment Used, Goals, Self-Evaluation, and Case Notes. The problem is with the Case Notes.) All of the tables except Client Demographics has an ID field which is not a primary key.
I have all of the tables in a relationship with the Client Demographics table. Example - when I open the Social Service Assessment from the Client Demographics - the ID of the client I am working with opens in the Social Service Assessment. These ID’s are in a relationship that says – Include ALL records from Client Demographics and only those records from Case Notes where the joined fields are equal.
The Case Note table has the Case Note ID, Date, Time, and Note. Now the table has Case Note 1 with all the fields, Case Note 2 with all the fields, through Case Note 6. When I open Johnny's case notes - and enter 6 notes - then I have to delete and start again – meaning I have top print out the first 6 before I can start with the next 6 notes for that one client.
Now – how do I have unlimited Case Notes for only 1 Client ID. Example – Johnny is the client and each time I see Johnny I make a case note. This may be ongoing for several years. How do I keep all of those notes with Johnny’s ID number and then have other clients with their respective ID numbers and all of their case notes?
This is probably really simple - but I just can not figure it out. I have made it work by printing out the old notes and starting over - but would like to keep all of the notes for each client in the database.
Again - I am in no way a programmer - just found that Access makes my documentation easier. Any help will be appreciated.
