As in your case it is very hard thing to write all the procedures and steps. I am thinking to design my db just like you did. Simple is the best! Thanks for your advices, they are very valuable for me..
--- In MS_Access_Professionals@yahoogroups.com, "Robert" <robert@...> wrote:
>
> My first Access database was something very similiar to this, only it was an electronics manufacturer. They had several different departments, and within those departments, there were multiple different "steps" of the process. Not all items that they manufactured went to each "step" or even to each department. Therefore, I just made a table that listed each and every possible option (step/dept - actually, the process steps were labeled like 1.3, 2.5, etc. where the first number is the dept and the 2nd is the step in the process).
>
> Anyways, I didn't bother making a set procedure for each item they produced, it would have taken just as long to make that capability as much as it took for me to write the entire program. Also, they were always making prototype stuff, and new products, so it would have been a never ending job, and a headache to keep track of in the database system. So, I just left it up to the person making the changes in the "Works in Process" report, they had the option of taking the item from whatever it's current location was to any other location within the plant. This also left the option open that if they ever started to make a product that required a step they never did before, that they could just go into the table holding all the jobs/steps and make an addition. One thing to be careful of was, I didn't allow them to delete any absolete steps because all the items that used to pass through that step would lose the reference, so I had an "active" checkbox so it wouldbn't be displayed as an option if the process ever stopped receiving any products.
>
> --- In MS_Access_Professionals@yahoogroups.com, rkulez <no_reply@> wrote:
> >
> >
> >
> >
> > 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