Ruhi-
Perhaps you need something like a tbl_CaseDetailsActions related to
tbl_CaseDetails. You might also need a tbl_ProductsAndFeesProcedures linked to
tbl_ProductsAndFees. The Procedures table could list the "normal steps" needed
to produce a particular product or service. When you choose a particular
product in tbl_CaseDetails, you could pre-load tbl_CaseDetailsActions from
Procedures to provide a template for the steps that should normally be followed.
You'll have to decide what additional info belongs in the Actions table - such
things as date started, date completed, employee, etc.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of rkulez
Sent: Monday, June 27, 2011 8:02 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: process tracking
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
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar