I am trying to create a database for managing and reporting on defect tags applied to equipment with our facility. I have set up an employee management database to manage our employees and their roles within the facilty.
I have linked this database to the "Tags" database to recored who applied the tags and who's responsibility it is to complete the tasks assigned.
In the Tags database i have 8 Tables;
Tags (Actual information relating to the Tag raised)
Actions (Actions required)
Defect (Defect categories)
FLOC (Functional locations of the machinery)
Line (Processing Line)
Machine (Machine on the line)
& Employees (Employees who raise and action tags)
Im at the stage of trying to develop a User Interface for entering Tags into the Database. Everything seems to be working, except the combo boxes based on query's.
rpeare, I had a look at the sample database you sent back. The FLOC combo box does not appear to be working in that one either.
Sorry for all the questions, I am new to Access.