I think I may be able to do away with the ::Diary table at really will really just be a report of appointments? I could just run reports "day", "week", "month" layouts?
Although long term I'd like a calendar function so I could input appointments directly into a layout where I am viewing currently booked in clients or available slots but it seems an outside plug may be the simplest option.
These may also help.... The DB is generally to replace these to start with as I will use an iPad during initial Assessment to record patients details and again after to record details of treatment I've given (legal requirement).
and also this treatment record
In case you prefer this view I have included a screen shot from my current Relationship Graph.
Each case should only really have one Initial Assessment and one treatment plan. Medical History may change from one session to the next so i intend to use a look up and a tick box on my "appointment/treatment" screen/layout to confirm "No changes since last appointment" if that is the case.
Again thanks for your time
Seedcode has a free calendar template, with instructions on how to integrate with your database, or just bolt it on.
Yes I had looked at SeedCode's before. Do you have any thought on those free calenders? Limitations?
Any glaring errors or better solutions to my current over view?
Here's another free calendar: https://www.dropbox.com/s/e8d03xvwe8vtz85/Calendar.fp7
It's a "no frills" calendar but also has a very simple design and thus may be easier to integrate into a different solution. People using FileMaker 12 or newer can use Open from FileMaker's File menu to produce a copy of this file converted to the .fmp12 file format.
Any thoughts on my current blueprint? As above any glaring errors or improvements?
The basic data model seems workable.
Phil, I tried opening the calendar.fp7 in DROPBOX. It showed that a table was missing on the CALENDAR layout. Am I missing something?
Best guess is that your copy some how got munged during the download. I just did the following with no issues and no missing table:
Clicked the download link in my previous post
Clicked download on the drop box page that opened
Launched FileMaker 13
Used Open from FileMaker's File menu to open the file
FileMaker 13 produced a converted copy with no trouble and the layouts do not say "table missing" anywhere that I can find.