Stock Calculation

[Geoffk]

Hi All

I am seeking the solution to a problem with calculating stock adjustments

We use a job code which comprises several stock items and labour which = a $ value

I have a form "work in progress" where I enter all the job details including the job code, the aim is to reduce the individual stock items from a table "Stock" when the job code is entered.

JobCode 25WE = 1 x power point, 25metre cable , 9 x clips

I have tried several methods but to no avail, is there a way of doing this

Thanks in advance
GeoffK

 

[neileg]

Way too little information to be able to help. What tables do you have, fields and relationships?