I

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Holden - 24 Jul 2007 01:48 GMT

I have a Lock Out Tag Out db for doing maintenance at a power plant. This db
puts equipment ID and status on a list so that maintenance can be performed
safely. Some maintenance is repetative, so we build many similar tagouts.
How can I store sample tagouts so that I can develop a standard tagout?

Analogous to a standard customer / product sales mix. Perhaps each customer
would buy the same 12 items to start being a customer and you wanted to speed
data entry.

Reply to this Message

AccessVandal - 24 Jul 2007 02:50 GMT

Hi,

You have bad header.

>Holden wrote:
>I have a Lock Out Tag Out db for doing maintenance at a power plant. This db
>puts equipment ID and status on a list so that maintenance can be performed
>safely. Some maintenance is repetative, so we build many similar tagouts.
>How can I store sample tagouts so that I can develop a standard tagout?

For a start, create a sample table of tagouts and create a table for standard
tagouts.
With the table standard tagouts bound to a form, create a button to insert a
new record base on the Sample tagout to auto populate this form.

>Analogous to a standard customer / product sales mix. Perhaps each customer
>would buy the same 12 items to start being a customer and you wanted to speed
>data entry.

You might want to include another column/field, called it something like
"CustomerRating".
and in a combo box, query it by the "CustomerRating", use this combo box to
auto populate your form.

Signature

Please Rate the posting if helps you

Reply to this Message