How can I create a depreciation field in my item grid

Scriptcase 8 Discussion
#1

I am going to create a inventory database, in this way I created different tables such as: invoice, items, donor, provinces, category, vendor, staff and status. in this way I need to create new field to calculate the depreciation in item table. I consider the formula of depreciation in below way:
amount (purchased amount of item in item table) - depreciation time (category such as: furniture of laptop has unique depreciation time I consider it in category table) = depreciation
amount (purchased amount of item in item table) - depreciation = value of items depreciation (in first year)

I want to bring it to new field of item table as well as create a graph with it.

#2

Create a new field in the grid and in event OnRecord you code ala {my_new_field} = <your code to calculate the new field>

#3

Thanks for your respond, but how can I select field from another table, for calculation of depreciation I need to bring some field from another table.

#4

Look at the SC SQL Macros and at the right side from event editor …