John,
Thank you very much for your valuable guidance. It shows me the way but there is a question: procedures can be repeated in some steps and we can not determine the number of these steps. For example a dentist can make a try in 3 times etc. How can we solve this?
Ruhi
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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