>Yes, I am still trying to understand what each table is supposed to hold.
Sorry about the trouble but
-Items Master is the main table with all items here in any cases.
-BOM Master is a child table for Items Master containing Bill of Material items (from Items Master of course) and it's qty.
-Secondary Units Master is the table which contains the names of packings eg. 1kg, 10kgs, etc. and is a master
-Secondary Units Stock is a child table for Items Master where in specified SecUnits as selected from the SecUnitsMaster and its qty. and conversion to the main units details.
>I am not sure about the terms used. But since a) each item can contain several materials, and b) each material is >contained in several items, you can't save this information in items or in materials, and you need a separate table (to >solve the many-to-many relation).
Is it in the above?
>Do you need a hierarchy ("A" contains "B", "B" contains "C", etc., perhaps for several levels), or do you want to consider >this for future expansion?
Will my BOM Master suffice for this?
>OK: This will require a table, where you have the quantities in stock, for different units. You may also want to have a >table where you have the totals - for instance, for one particular item, everything converted to kg.
Will my Secondary Units Stock child table do it as you envision it?
>So you want to keep track of stock in different locations.
>
>In this case, your detailed stock table simply has one record for each combination of item, unit and location:
>
>
>Item Location Unit Quantity
>Sugar Main Warehouse 1 kg. 100
>Sugar Main Warehouse 10 kg. 30
>Sugar Suburbs 1 kg. 35
>...
>
>
>You may consider summary tables, which combine stock for all warehouses, for all units (converting to a single unit) or >both, but you can also do this by reports only (do the summary calculations when they are requested).
Any datails
And finally at the time of transaction data entry totally undiscussed yet, do I have to get the Item, SecUnit, Location or is there a better way than such brute force data entry?
Your discussion is really helpful and I appreciate the same. Thanks.