Our company performs repair work on motors. All our production records are stored and manipulated in MS Access. Various stages of production need to have updates done and this is one of the stages.
This project is for the development in MS Access of a custom report format based on 5 given table formats. I need to briefly describe the condition and recommended work for each repair order by:
1. Selecting the unique job number from the work order table
2.? Pulling customer identification information from the linked customer file
3.? Stuffing the temporary report with specific work order information from the work order table
4. Selecting from a table of standard report comments
5. Having the option to insert new comments that either become permanent system comments or simply custom comments for that particular report
6. Storing the report header information along with report date, revision, etc. in? one table
7. Storing the specific comments in a report detail table
## Deliverables
One other legal matter:
**1. I may supply sample data with real customer and work order information. This information is considered proprietary and must not be disclosed or used for any purpose other than developing this report.
**
I have attached the file called "[login to view URL]" which contains the 5 tables (empty) referred to in the description. The WO and Customer tables already exist within our larger production system and are not alterable. The remaining tables that will contain the system comments, report header and report details are new tables with some common (and not alterable) fields. The remaining fields may be changed if we agree alterations as the project progresses.
Specifically, I need a form where I? select a? work order from the WO table, your form will pull all the necessary fields from the WO and Customer tables and then wait for me to add comments selected from the system comment table.
When finished, your form will create a header record in the header record table. It will also? add? as many detail records as I've selected when using the form. The header and detail records will all be linked by the same WO number that I select at the beginning.
If a system comment doesn't exist then your form should allow me to enter a custom comment. When the custom comment is complete your form should store it with the other detail records AND ask me if I want it to become a new system comment that will become available the next time the form is used.
I use a specific form now and have included a scanned image showing where the particular fields will appear but **DON'T WORRY ABOUT THE APPEARANCE**. Just know that the header information will be placed at the top and **THERE SHOULD BE 4 DIFFERENT ENTRY POINTS FOR COMMENTS**. But all comments will come from the same system comments file.
Just email me with questions.
Thanks.