Please help

From: BG (anonymous_at_discussions.microsoft.com)
Date: 06/01/04 

Date: Tue, 1 Jun 2004 09:01:23 -0700

Here's my quandary:
In our research facility, processing of product involves
several steps. The first 2 steps are the same for all
product. I capture that information in 2 tables;
tblComposition and tblManufacturing. TblComposition has
fields for LotID, Component, and Amount of Component (a
LotId can have 1-8 components). TblManufacturing has
several fields including LotID, MfgEquip, Operator, etc.
Some Lots are split out at this point to "child" Lots and
receive additional processing, tblPostProcessing with
fields LotID,ParentID,PPEquip, etc.. Both parent and child
go on to get tested and assembled. When I run queries on
the end product I need to know the Composition and
Manufacturing details so to simplify the process I thought
it best to copy that information from parent to child lot.
An append query or 2 seems like a good option but I need a
way for users to execute the queries perhaps from the form
when the child Lot gets created and postprocessed. Any
ideas on this or a better method to accomplish what I
need? Thanks for the help.

Relevant Pages

  • Safely timing out DBI queries
    ... plenty of data and hence plenty of rope. ... themselves by timing-out long-running queries and killing the MySQL ... Parent forks a child before starting long-running query. ...
    (perl.dbi.users)
  • Re: Difficulty in implementing
    ... The textual content in the parent table will make the "table wider". ... textual column is involved in other queries, storing it in a child table ... you will get better performance by storing it in a child ...
    (microsoft.public.sqlserver.fulltext)
  • Re: How do I empty a table?
    ... You write a series of queries that delete data from each table. ... Delete the records in any child tables before you delete the records in any ... parent tables. ... Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia ...
    (microsoft.public.access.gettingstarted)
  • Re: Linking 4 child tables to 1 Parent table
    ... There are situations in which keeping 1-1 "child" tables makes more sense. ... separate tables will probably be OK. ... I'm not clear which queries you are referring to, but I do know that you can ... right now they are linked to the key field of the parent, ...
    (microsoft.public.access.tablesdbdesign)
  • Unix Programming FAQ (v1.37)
    ... Why use _exit rather than exit in the child branch of a fork? ... Why doesn't my process get SIGHUP when its parent dies? ... How do I create a named pipe? ... How do I compare strings using regular expressions? ...
    (comp.unix.programmer)