Hello Walter, I just suggested that possibility based on my understanding of your idea to separate the personal data of the hospital's personnel from the patient data. Since the personal data are the same, you can use the same structure. Of course this means that once a hospital's employee gets sick and himself becomes that hospital's patient, you might need to reenter his personal data as a patient. This means double work and redundancy of data.
I personally wanted to avoid this redundancy thats why there is currently only one person data table and it also contains the data of the hospital's personnel. But I understood your last posting that you might need a true separation so I suggested the previous solution. Please correct me if I am wrong. Elpidio On Wednesday 10 November 2004 16:33, Walter Nunez wrote: > Thank you Elpidio. > but, in this table..personnel and patients > � Why they share the same table as original design? ------------------------------------------------------- This SF.Net email is sponsored by: Sybase ASE Linux Express Edition - download now for FREE LinuxWorld Reader's Choice Award Winner for best database on Linux. http://ads.osdn.com/?ad_idU88&alloc_id065&op=click _______________________________________________ Care2002-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/care2002-developers
