The database I am working in houses various information related to the company's manufacturing processes. My current project is dealing with cutting tools related to machining operations. Each tool has a unique tool built sheet, housed on our network. I would like to determine which tools do not have a build sheet. I have no idea how to go about this.
The database contains a table, listing each tool and other information about such. Each tool has a unique name, such as "CG4023" or "MS8260". The tool build sheets are PDFs and have the same name. It is not uncommon for new tools to be created. Also, some of the tools listed are no longer used. There is already a reporting system in place, relaying when tools are no longer needed, and can be removed from the plant floor.
Once this check is working, I would like to create a report that can be run to show which tools still need a build sheet. If possible, I would like to only look at the tools that are currently being used. I do have a query for this already. This report would need to be able to run often, as the active tool list is constantly changing. I'm just not sure how to go about checking if the files are there.
Any advice on this would be greatly appreciated. I will do my best to provide any other information that is needed. If its of use to know, I did not build this database, but am now the only person who changes / maintains it. However, other people do change information through forms.
Thanks!
The database contains a table, listing each tool and other information about such. Each tool has a unique name, such as "CG4023" or "MS8260". The tool build sheets are PDFs and have the same name. It is not uncommon for new tools to be created. Also, some of the tools listed are no longer used. There is already a reporting system in place, relaying when tools are no longer needed, and can be removed from the plant floor.
Once this check is working, I would like to create a report that can be run to show which tools still need a build sheet. If possible, I would like to only look at the tools that are currently being used. I do have a query for this already. This report would need to be able to run often, as the active tool list is constantly changing. I'm just not sure how to go about checking if the files are there.
Any advice on this would be greatly appreciated. I will do my best to provide any other information that is needed. If its of use to know, I did not build this database, but am now the only person who changes / maintains it. However, other people do change information through forms.
Thanks!