AnsweredAssumed Answered

Table Problems

Question asked by RedzwanLatif on Aug 8, 2012

Title

Table Problems

Post

Hi. I got 4 tables. Patient, Appointment, CheckInOut, Clinical. There are two ways of patient's check in. First is direct checkin and the second one is through appointment . I'm lack of idea, so I made a script to create a silent way ( A script that create record in Appointment and create record in CheckInOut without stopping in the Appointment table layout ) for the direct check in. The problem is now I'll use Zulu for syncing data with iCal. I'm afraid that the Zulu will also import the "Silent Data" ( The data I used for direct method ) to iCal.

 

Is there any alternative way to do the direct check in? or any other alternative solution?

 

I've attached the screenshot of my relationship

 

Thank you :)

DCS_Appointment_Problem.jpg

Outcomes