Documents rows update
i have created a user query and i am using it to update my document row discount values when the doctotal value changes.
My problem is when the document number changes i have to go into the discount fields in the row and click in for the value to change. I dont want it that way.
I want a way that when my doctotal changes anytime the discount row values will change automatically. if my row values are total are 10 immediately my doctotal changes it should update all 10 rows discount column with the discount values.
Urgent help will be appreciated