SQLite & repeated fields

[mfstuart]

Hi Sarah,
How familiar are you with the concept of Bill of Materials, Production
Orders, etc.?
Where a sellable (or shippable item) is made up of components, and the
components are assembled to gether with many other items - either purchased
or sub-assemblies.
This is the Bill of Materials - the structure of an item.

When a customer order is processed, the manufacturing dept produces the
Production Orders, which looks at the B.O.M. and produces the Manufacturing
B.O.M. - this is an expanded production order with all the customer orders
multiplied against the B.O.M., which the assembly plant knows how many to
make.

There are books on this on how to define the tables that hold the data, but
I'm sure you could find this info online. It's reasonably elementary.

If you need more help, let me know. :)

Regards,
Mark Stuart


Sarah Reichelt-2 wrote:
> 
> Hi All,
> 
> I'm setting up an SQLite database and having some problems with table
> design. The app is inventory control with a "Make" function i.e. it
> stores the quantities of each raw material you have and when you
> "make" a specified amount of a certain product, those amounts are
> automatically deducted from the raw material stocks.
> 
> I have a very simple table for the raw materials, but the products
> table is not so obvious (at least not to me), mainly because each
> product will have a different number of items used in it's
> manufacture.
> 
> Do I have to set up a large table allowing for the maximum possible
> number of items?
> e.g.
> product name
> product id
> item 1
> quantity 1
> item 2
> quantity 2
> .
> .
> .
> item 50
> quantity 50
> 
> or is there any better way to hold a variable number of repeating fields?
> 
> TIA,
> Sarah
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
> 
> 

-- 
View this message in context: http://www.nabble.com/SQLite---repeated-fields-tp21343545p21345538.html
Sent from the Revolution - User mailing list archive at Nabble.com.