Hi,
One of the businesses is to provide procedure. So when a procedure or two has/have been done to a patient:
1)a sales clerk will prepare a billing form (attached and the tab is "Billing Template" ) accordingly
2)a purchase clerk will also prepare purchase order (attached and the tab is "Purchase Order Template") on weekly basis to supplier when consignment items are used
However, the final works also come with mistakes like the consigments miss out, item description wrongly provided, reference no double, etc. Hence, I am thinking of using Ms Access to manage the whole issue. They will key into Access and I will generate report to see what have been missed out and corrected from there. Of course, billing form and purchase order will be printed out from Access also. I am not certain if it can work, but i would like to give it a try.
So far, I have done the table planning (attached and the tab is "Table Design).
Could someone please give comment on my planning and the queries stated therein?
Thank you very much