Posted by ss54 on May 30, 2012 at 8:06pm
I used to use Foxpro to enter a transactional data for records on a master file. Suppose for example you have a master file for patients whose name, address, date of birth, etc were already recorded. But suppose a patient from this master file has to visit the same clinic at different times in a month or a week or as he/she needs. When this patient visits the clinic, his date of visit, reason for visit, medications prescribed and so on. On each visit these changing info will have to be registered for each of his/her visit. These registrations are called transaction data and there must be a relational transaction file for this purpose. is this possible in Drupal?. Thanks for any information on this.
Comments
gets rave reviews
but I personally haven't used it...
http://www.supersaas.com/tutorials/drupal_appointment_scheduling
Don't panic! Whatever you do, don't panic! Unless, of course, you didn't make a backup - then by all means freak out...
Yes, you can do that with
Yes, you can do that with Drupal. One common approach is to represent the patients as users or a content type (depends on if you want them to be able to log on to the system) . Then you can represent each visit with a content type that uses a entity reference field to refer to the patient
Many thanks for this hint
Many thankz for reminding of the reference uses. Is there any example or tutorial on the web on this?
A search with Google found
A search with Google found http://dev.nodeone.se/sv/node/1054
What I am thinking to do
Thanks. I am thinking to create a content type for employee containing many fields like
Tile: name of employee
No. of employee: (not sure)
Address of employee
Date of appointment
--------------------------------------
After that I intend to cretae another content type (Transaction file in this case). In this content type I intend to create a field (application date for a sick leave), another field is (no. of days taken on that date)
An employee get 1.5 days every two months. This might easily be calculated by using a date function. But I wonder how I associate these two fields with a specific employee. I mean how this date and no of days recorded against a specific employee in the master file. Can you give me an idea please. i used to do this in the eighties by dbase foxpro programming.