Hello All,
I am currently working on an my first Access application and
thought I would ask the group for suggestions about how best to
implement certain features...
The project is for a semiconductor manufacturer to track various
lots through the various stages of the manufacturing process and
inventory. So far it's relatively simple with one main table
containing all known lots and a few other supporting tables for part
numbers, shipments, etc.
I was looking for suggestions on how to:
1) Implement "flows". There are a handful of different flows, each of
which is basically an ordered list of steps or locations through which
a given lot will travel. To make things a bit trickier, there needs
to be the ability to have "subflows" as well. For example, a lot may
have to go through a re-work flow before continuing on with the
original flow.
2) Lot History. I need to be able to recall the entire history of any
transactions involving a given lot. The problem is that even though
each lot has a unique lot number, that lot number may change 3 or 4
times before the product is finished due to lot splits, combining
lots, temporary lots, etc. Really not sure where to begin tackling
this one.
3) Comments. Kind of similar to #2. Need to be able to add one or
more short comments when necessary to individual lots. I guess I could
just add a text/memo field to the lot table, but the comments will
most likely be used very sparingly and so this seems like a huge waste.
I'll just stop there for now. I appreciate any comments/suggestions
that anyone might have. If I were to pick just one, I would say the
lot history is what puzzles me most.
Thank You,
Jim Beaubien
[EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
