I

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
Click to expand...

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.
Click to expand...

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.
 
Back
Top