Downtime system

[msnews.microsoft.com]

I'm trying to create a database using access 2000, this database will keep
track of equipment downtime,
I have several machine types each type of machine has several downtime
categories, I just don't know how to handle the downtime categories, 'cause
as I mentioned before each machine type has different downtime categories,
any help on how to start working on this will be greatly appreciated, thanks
to all.


Gerardo

 

[John Vinson]

I'm trying to create a database using access 2000, this database will keep
track of equipment downtime,
I have several machine types each type of machine has several downtime
categories, I just don't know how to handle the downtime categories, 'cause
as I mentioned before each machine type has different downtime categories,
any help on how to start working on this will be greatly appreciated, thanks
to all.


Gerardo

You may need a Categories table with two fields: MachineType and
Category. This would let you use a customized set of categories for
each machinetype.

On your data entry form you could use a Combo Box based on a query of
this table referencing the selected machine type. Use a criterion of

=Forms![your-form-name]![cboMachineType]

where cboMachineType is the name of the combo box (or other control)
containing the machine type.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Cheah Chin Thai]

Form my experience, you may look into the access2000 tool
menu, find the extra menu, then click to open the slip
control. Then you may store each type of runtime.