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 :)