R
R Whittet
Hello, I am re-designing a database that is used to store maintenance
information for equipment. It is a pretty large database in terms of the
number of equipment items being tracked. There are approximately 1500 items.
Most of the items can be grouped by a certain parameter such as valves or
pumps. However, there are several groups, I'd say between 30 and 40 groups.
I am looking for a better way to sort the pieces of equipment when entering
information in a form. The basic idea is to select the group from a combo
box to populate the smaller equipment list that shows only the items in that
specific group. The method I have been using for the past few years is by
defining the groups that each equipment item is listed under in my equipment
list table. I have a total of 3 different grouping options so that the user
can select for example pumps and chemical feeds to show only the chemical
feed pumps. I was wondering if any of the experts out there had any
suggestions for a better method to accomplish this task. Thank you for your
time.
information for equipment. It is a pretty large database in terms of the
number of equipment items being tracked. There are approximately 1500 items.
Most of the items can be grouped by a certain parameter such as valves or
pumps. However, there are several groups, I'd say between 30 and 40 groups.
I am looking for a better way to sort the pieces of equipment when entering
information in a form. The basic idea is to select the group from a combo
box to populate the smaller equipment list that shows only the items in that
specific group. The method I have been using for the past few years is by
defining the groups that each equipment item is listed under in my equipment
list table. I have a total of 3 different grouping options so that the user
can select for example pumps and chemical feeds to show only the chemical
feed pumps. I was wondering if any of the experts out there had any
suggestions for a better method to accomplish this task. Thank you for your
time.