Is OO Base good for this?
Posted: Wed Jun 27, 2018 1:03 pm
Hi everyone,
i have very little knowledge of this software and I'm learning it on the go but i keep staring at tables and relations just wondering if it's really suitable for my needs. So before i go further i would like to have your suggestion about it. Please, excuse my bad english.
I work in a silkscreen company that print on plastic packaging. For every production i print a PDF form that i give to operators to fill manually. In that form there are all the information and the steps of production (e.g. type of packaging, color of packaging, PANTONE colors used, their recipes, silk used, etc etc). When the production is done i get back the form and copy the information back in the PDF on my pc and i print it again to store it up in a closet. In my pc so far all the PDF are apart from each other, spread in folders organized by clients>code of production (every production has its own code).
My needs:
- a database where to find the form of any production i want (scenario: "I need to know what )
- a database with all the recipes ever done which i can find searching by PANTONE name. (scenario: "i have to do this PANTONE on this kind of packaging, have we already done it or i have to make the recipe from scratch? ")
- preserving the currently PDF form layout (as much as possible) the operators are use to fill.
I attach the database i'm working on. In wanted to add the PDF form as well but it looks like a can attach only one file... or i just don't know how to do it
Some information are already know and i could take it from already filled tables. Those information are: packaging type - packaging material - packaging color, all operators signs, silks, exposure, gelatin and machine.
I think the most tricky part is that every PANTONE color used has its own silk, exposure, gelatin, brand, inks and additive (but some of these info could apply even for other PANTONE colors). Also, in the form there's place for maximum 6 PANTONE colors but they could be just 1 or 2 or 3.... Just like the recipes: there's room for maximum 6 inks + 4 additive but i don't know it until i get back the PDF form from the operators.
Also, different production (so different code) could have the same PANTONE colors.. but still it doesn't mean they share the same recipes cause it depends on the color of the packaging, the silk used and so on...
So, i'm kinda lost here, any help would be appreciated. If you need to know more in order to give me solutions.. just ask.
I hope you all the best.
Cheers.
i have very little knowledge of this software and I'm learning it on the go but i keep staring at tables and relations just wondering if it's really suitable for my needs. So before i go further i would like to have your suggestion about it. Please, excuse my bad english.
I work in a silkscreen company that print on plastic packaging. For every production i print a PDF form that i give to operators to fill manually. In that form there are all the information and the steps of production (e.g. type of packaging, color of packaging, PANTONE colors used, their recipes, silk used, etc etc). When the production is done i get back the form and copy the information back in the PDF on my pc and i print it again to store it up in a closet. In my pc so far all the PDF are apart from each other, spread in folders organized by clients>code of production (every production has its own code).
My needs:
- a database where to find the form of any production i want (scenario: "I need to know what )
- a database with all the recipes ever done which i can find searching by PANTONE name. (scenario: "i have to do this PANTONE on this kind of packaging, have we already done it or i have to make the recipe from scratch? ")
- preserving the currently PDF form layout (as much as possible) the operators are use to fill.
I attach the database i'm working on. In wanted to add the PDF form as well but it looks like a can attach only one file... or i just don't know how to do it
Some information are already know and i could take it from already filled tables. Those information are: packaging type - packaging material - packaging color, all operators signs, silks, exposure, gelatin and machine.
I think the most tricky part is that every PANTONE color used has its own silk, exposure, gelatin, brand, inks and additive (but some of these info could apply even for other PANTONE colors). Also, in the form there's place for maximum 6 PANTONE colors but they could be just 1 or 2 or 3.... Just like the recipes: there's room for maximum 6 inks + 4 additive but i don't know it until i get back the PDF form from the operators.
Also, different production (so different code) could have the same PANTONE colors.. but still it doesn't mean they share the same recipes cause it depends on the color of the packaging, the silk used and so on...
So, i'm kinda lost here, any help would be appreciated. If you need to know more in order to give me solutions.. just ask.
I hope you all the best.
Cheers.