[AccessD] Manufacturing Application

Rocky/Stuart,

Thanks again for the replies, this has been put on a backburner for a while
at my friends works, so I will probably be asking again sometime in the
future, gives me a little more time to try and find some example databases
and structures and how these things are put together to give me an idea of
a generic system.  Now I have an idea for a type of remote time logging
application, what I need is something similar to the HSBC internet banking
key, where to logon a person has to have an ID generated by the HSBC key to
use the account, anyone have any experience of working with something like
this, basically there would be these keys at static locations, a person
arrives at these locations generates a code with the key then sends that
code via SMS (think I have the SMS piece and the rest of it) the code will
need to be random like the HSBC key i.e. I think it uses part of account,
time and date etc....then when code comes into the database it can be
checked and if matches knows the location details of where that person is,
if not then alerts the user by SMS to try again.  I did think about writing
a mobile app but not all locations will have internet access for wi-fi and
don't want to use the users own data usage which is why I am letting them
send by SMS, so the only problem I can forsee is the random code matching
from location to base.

Thanks in advance

Paul


On 27 February 2014 21:13, Stuart McLachlan <stuart at lexacorp.com.pg> wrote:

> Coming back a bit late = I was trying to track down the application but
> can't find a copy.
>
> I built exactly this a number of years ago. The company used it for
> producting all the paint
> manufactured in PNG until their parent company overseas was bought out by
> Akzno Nobel
> and they had to change to AN's worldwide system.
>
> You are looking at a a wide range fo chemicals that come in bags and drums
> and
> forumae/processes to convert them into paint.   There are quite a few
> mixtures which are
> made up in advance and can then be used in formulations so you have some
> things which
> are treated both as material and product.
>
> The formulations will be recorded as  a series of steps with quantity of a
> component to be
> added and  a description of that stage.  The production sheet needs to
> generated for each
> paint batch based on the formulation, formula and qty to be produced..
>
> Quantities in a forumla will be either weight based on volume based and
> you need to record
> the specific gravity of each liquid ingredient and end product so that you
> can  convert it to
> weight.  Quantities in formulae are per lb/kg or whatever.
>
> So there is a bit of math involved in converting a formula listing
> vomponents in grams/kg into
> a production sheet listing quantities and steps to produce 600 litres of
> end product.
>
> That's the simple part.  Then comes stock control, production scheduling,
> material
> forecasting, sample testing results etc, ect.
>
>
>
>
>
> On 27 Feb 2014 at 9:23, Paul Hartland wrote:
>
> > Rocky I will get back to you at some point, as soon as my friend can
> > get back to me, as a start I have asked (probably the wrong question)
> > if he could supply me with a list of all raw materials they currently
> > have that are used in the manufacture of this specialised paint, so at
> > least I can look at building a sort of raw parts inventory.
> >
> > Paul
> >
> >
> > On 26 February 2014 13:45, jack drawbridge <jackandpat.d at gmail.com>
> > wrote:
> >
> > > Paul,
> > > There are a number of free data models at
> > > http://www.databaseanswers.org
> > >
> > > use google or bing and use this search term
> > >
> > > *databaseanswers.org <http://databaseanswers.org> data model
> > > manufacturing*
> > >
> > >
> > > On Wed, Feb 26, 2014 at 1:55 AM, Paul Hartland <
> > > paul.hartland at googlemail.com
> > > > wrote:
> > >
> > > > To all,
> > > >
> > > > Has anyone had any experience in designing and developing a
> > > > manufacturing application, I am trying to find a database model or
> > > > example database to get an exact idea of requirements, basically a
> > > > friend of mine works as
> > > head
> > > > accountant for a specialist paint manufacturer and he says there
> > > > just
> > > isn't
> > > > anything out there to do exactly what they require, so being
> > > > clever I
> > > said
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com