>Hello Borislav
>
>I must need to store the result of calculation in the table, because i must keep this value on them and if i changed the original controlsource of my columns that is "FI.U_VALHUM" to ((0+fi.u_nospeso-fi.u_VLDscemb)*fi.u_hum)/100, when i save my invoice my sql table loose this calculation value , the field FI.U_VALHUM = 0
>
>Also if like i said by some line of code i can know the colunm index numbers, i can write
>replace FI.U_VALHUM with QTT*100 for example, and also without changing controlsource.
>
>in fact , my program use remote views to send values to sql server database.
>
>I hope you understand.
>
>thanks
>Luis Santos
No Luis, Sorry.
I still don't understand WHY YOU NEED to keep calculated values in the table. This is not a good design. Maintenance is a nightmare and you always can get that calculated values back whenever you want (especially if your backend is SQL Server).
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.