Thread: CaseManagement
View Single Post
  #2  
Old April 19th, 2010, 09:33 PM posted to microsoft.public.access.tablesdbdesign
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default CaseManagement

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/For...esign/201004/1