I'm attempting a 'Document Translation' managment database.
I've attached a file that contains only my tables because I don't know if what i'm starting with will give me the solution that i'm hoping to end up with.
I've related those tables in order to create a functional system for building a database of document translations. my responsibilities include. managing the docuements that we have, managing the corresponding translations of that document, the versions of each origional/translation. logging document translation requests, ordering from verndor translation companies, and sending translated documents copies to departments who sent the original request, in our network, via email (or might develop an intranet depository/folder for all translations that we have to-date).
so, a typical process will be: (dept & document names provided for example only)
- We get a request from RADIOLOGY for a cambodian translation of a Pre-Procedure Preparation document.
- I search the database to see if we already have that form translated, and which languages it was translated into already.
- If we have it, I'll attach that request to original English document that we already have in the document table, log date time, etc., and forward the requested language translated document to that department by email. At that point, the only thing thas changed in the database is a new request for the existing original English document was logged (would already be in the Document Table) and the translation sent to fulfill the request was logged.
- If we do not have the original document yet, it becomes a new Record entry into the document table. the translation request from the department will have to be related to this new document record. A new language will have to be identified if it is not already (i have most possible lanuages in a vlookup in the language field).
- I would then have to send a request to the translation company for a quote on the translation. Both the request and the quote will have to be related to the original document
- When an acceptable quote returns, I'll attach that quote/invoice to the specific language that is being requested, which should already be related to the original document. Payment should be tracked and related to this translation request, but the PO # is generated by the business office.
etc....
you see everything related to this translation managment database logs, attaches to, tracks, or relates to, in some way, to the original English document that needs to be translated to a foreign language.
MY PROBLEM/QUESTION is, whether i need to have every part in a separate table, as I do now, and how to relate those properly, and how to create queries, forms and reports based on the information in these tables.
I'm tackling a large project for knowing as little as I do about the process.
Thank you for any help that someone can give. I've had paid help with some excel projects, but i didn't see a "commercial" option here in the access forum.
David