CaseManagement
in [Tables]
|
From: Joe on 19 Apr 2010 14:24 Hi all, Just created a database to keep track of case management for clients. I have all demographics, types of case management intervention, but I'm having problems with the notes. How can I make the notes field do auto spelling? How can I add "relationship" with ClientDemoghapics and types of case management with the case management notes field?
From: PieterLinden via AccessMonster.com on 19 Apr 2010 16:33 Joe wrote: >Hi all, >Just created a database to keep track of case management for clients. I >have all demographics, types of case management intervention, but I'm having >problems with the notes. > >How can I make the notes field do auto spelling? How can I add >"relationship" with ClientDemoghapics and types of case management with the >case management notes field? Hard to explain without pertinent details about the structures of your tables! Your description is not complete somehow. When I wrote one of these a million years ago, the basic structure was: CaseWorker---(1,M)---Case---(1,M)---CaseNotes You can just include a text field in your CaseNotes table that indicates what kind of note it is. The foreign key tells you which case it's related to. Spelling... figured Terry would have it, and of course, he does! http://www.accessruncommand.com/codeex/269.htm -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201004/1
From: PieterLinden via AccessMonster.com on 19 Apr 2010 16:37 Joe wrote: >Hi all, >Just created a database to keep track of case management for clients. I >have all demographics, types of case management intervention, but I'm having >problems with the notes. > >How can I make the notes field do auto spelling? How can I add >"relationship" with ClientDemoghapics and types of case management with the >case management notes field? Hard to explain without pertinent details about the structures of your tables! Your description is not complete somehow. When I wrote one of these a million years ago, the basic structure was: CaseWorker---(1,M)---Case---(1,M)---CaseNotes You can just include a text field in your CaseNotes table that indicates what kind of note it is. The foreign key tells you which case it's related to. Spelling... figured Terry would have it, and of course, he does! http://www.accessruncommand.com/codeex/269.htm -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201004/1
From: roccogrand on 24 Apr 2010 19:14 Joe, In Access 2007, auto-correct is controlled by Access Options as a Proofing feature. Use the Office button to add words to the global dictionary. Alternatively, add words to the Office dictionary in MS Word and they will be enabled in Access (and PowerPoint). You can also customize the Word 2007 interface by adding an Auto-Correct icon to make faster changes to the dictionary--again via the Office button. HTH, LDN "Joe" wrote: > Hi all, > Just created a database to keep track of case management for clients. I > have all demographics, types of case management intervention, but I'm having > problems with the notes. > > How can I make the notes field do auto spelling? How can I add > "relationship" with ClientDemoghapics and types of case management with the > case management notes field? >
|
Pages: 1 Prev: create and print payroll check w/office Next: Link fields if found |