Current Situation:
I have a table that is used to identify what an employee currently has as far as equipment, furniture, etc.
The form has a combo box for several different categories such as Chair, Work Surface, Keyboard, Monitor, Telephone, etc.
Previously, I had a table for each category where I would list the different items. For example:
TABLE: ItemListChairs
RECORDS:
Drafting Stool
HAG
Standard
TABLE: ItemListWorkSurfaces
RECORDS:
Desk Surface, Corner W/S 48*30 (cut out)
Desk Surface, Mayline Adjustable Unit
TABLE: ItemListKeyboards
RECORDS:
MS Ergo
Regular
The users wanted to be able to manually enter items into the ItemList tables when needed. The problem I see now is that the "categories" have expanded. I'm now looking at approximately 10-15 different "ItemList" tables.
GOAL:
I have combined all the items into one table called ItemList. I've added a field called "Category". An example of a record would be:
Category: CHAIR
Description: HAG
Cost: $350
Responsible Party: Facilities
I would like to set up the combo box to filter the list. For example, if I'm in the field called "Chair Type", I'd like to look at my combined ItemList table (via combo box), and only show those records where the category is CHAIR. Right now, I see ALL items.
I understand that I would have to customize this for every field on my form, but I figure setting it up initally for 15 fields is better than maintaining 15 tables.
Thanks so much for your help!
I have a table that is used to identify what an employee currently has as far as equipment, furniture, etc.
The form has a combo box for several different categories such as Chair, Work Surface, Keyboard, Monitor, Telephone, etc.
Previously, I had a table for each category where I would list the different items. For example:
TABLE: ItemListChairs
RECORDS:
Drafting Stool
HAG
Standard
TABLE: ItemListWorkSurfaces
RECORDS:
Desk Surface, Corner W/S 48*30 (cut out)
Desk Surface, Mayline Adjustable Unit
TABLE: ItemListKeyboards
RECORDS:
MS Ergo
Regular
The users wanted to be able to manually enter items into the ItemList tables when needed. The problem I see now is that the "categories" have expanded. I'm now looking at approximately 10-15 different "ItemList" tables.
GOAL:
I have combined all the items into one table called ItemList. I've added a field called "Category". An example of a record would be:
Category: CHAIR
Description: HAG
Cost: $350
Responsible Party: Facilities
I would like to set up the combo box to filter the list. For example, if I'm in the field called "Chair Type", I'd like to look at my combined ItemList table (via combo box), and only show those records where the category is CHAIR. Right now, I see ALL items.
I understand that I would have to customize this for every field on my form, but I figure setting it up initally for 15 fields is better than maintaining 15 tables.
Thanks so much for your help!
