John,
Excuse me I'm replying late because I was very busy. Thanks for your advices. They will guide me. Thanks again.
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> 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