I

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.
 
A

AccessVandal via AccessMonster.com

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top