Do you mean something like select sum(quantity) from sub_items where component_name='Tyre'? This would give you 8 in the case you described, but I'm not sure what this number would mean ...
In any case 'Find' , 'Advanced Find' or 'Database Query' should do the job.
To use the full functionality of this web site, JavaScript needs to be turned on.
For best results, use the Firefox browser..
Copyright © 2003-2017 - Tersus Software Ltd., All rights reserved. Terms of Use License Graphic design by EmaraDesign