L'apprentis
Redcifer
- Local time
- Today, 11:01
- Joined
- Jun 22, 2005
- Messages
- 177
I am not sure how to deal with the weight of my items in my BOM system.
I have got a TblItem Linked to a TblComponent that establish the relationship between each items (Assemblies made of various parts with assemblies and part stored in the same tblItem)
I have a field weight in the TblItem, there is no value for the weight of Items that are assemblies as the weight can be calculated after by summing the weight of the components. How can I create a query which could show me each Assembly and each component Weight?
I have got a TblItem Linked to a TblComponent that establish the relationship between each items (Assemblies made of various parts with assemblies and part stored in the same tblItem)
I have a field weight in the TblItem, there is no value for the weight of Items that are assemblies as the weight can be calculated after by summing the weight of the components. How can I create a query which could show me each Assembly and each component Weight?
Last edited:
