Ruhi-
I merely suggested copying "template" rows to make it easy to handle a standard
case. You should certainly allow the user to enter additional Actions by simply
adding a row and selecting the action from perhaps a combo box.
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: Tuesday, June 28, 2011 12:56 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: process tracking
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
>
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar