"Session" notes?

[torifile]

I'm working on a database for managing my clients and session notes. Each client has a "patient ID" and each client has a number of sessions associated with them. My thinking is that I'd have a portal with a list of session dates that could take me to a "note" layout to write the note for that particular day. Something like

where clicking on the checkbox will trigger a script. Does that make any sense?

What do you think would be the best way to accomplish this? I've currently got a "master" key table which is related to the sessions table through a foreign key relationship. I'm using FMP 9.

Edited April 18, 2009 by Guest