Dear Bill and all masters,
In my db the tables and the fields are as (simplified):
tbl_Customers (dentists)
CustomerID
Name
Address
...
tbl_ProductsandFees
ProductID
ProductName
ProductFee
......
tbl_Cases
CaseID
CaseStartDate
PatientName
CasePlan
CaseColor
CaseDueDate
.....
tbl_CaseDetails
CaseID
ProductAmount
ProductID
.....
tbl_Employees (most of them are dental technicians)
EmployeeID
Name
DepartmentID
.........
tbl_Departments
DepartmentID
DepartmentName
......
The prosthesis production begins with the registration of the case. After registration, for example a ceramic crown production process: Model Prep Department-plaster model production..Wax Modellation Department-wax modellation..Casting Department-casting of wax crown in metal..send the work to dentist for try in..after try in, return of the crown to lab..Ceramic Department-ceramic firing on to metal crown
..send the work to dentist for try in..after try in, return of the crown to lab..Ceramic Department-Glazing(polishing) of the ceramic crown....send the work to dentist for the final delivery.
I want to track the case in the lab. For example I want to know where is a case (in which department?)querying with ID or patient name. I want to know what the departments is doing in that time, beginning and finishing times of the process in that department,etc.
Thanks for your help in advance,
Ruhi
Tidak ada komentar:
Posting Komentar