i have created an global variable called ColmNo as integer. And i have a table with various fields. what i want to know is how to set the colmNo for each field. like if my table has 4 fields say FIELD1,FIELD2,FIELD3,FIELD4 then i want to assign the ColmNo has this,
i have a form which picks up value from another and on changing this picked up value the color wil change!
Now i have kept a button called default and an global var ColmNo as int, What i want is , on clicking the default button after selecting an colmNo, the value in that field should revert back to its original one(the one which was there before changing it).
thats why i want to know how to assign the fields to this colmNo.
No i want the values in the form to change…oh i thought tables are just to view! And all the changes must be done in a form,which stores the changes in the table…
And as i said i have a global variable called colmNo as int, which i have mapped to a text box and placed in the bottom of the form. And have kept another text box, which is mapped to my entry no! So now this Entryno acts as the line no for me.
So say i have 5 lines in my form,i want to revert back the value of 2 line’s colmNo 4…so i will select the line 2 in the entry no and type 4 in the colmNo text box…then On pressing the default button the action should perform.
If I’m following correctly… If you click on the field with the red 8.00 and hit your default button - you wan’t the red 8.00 to change to it’s original 7.50 (example) black number. And if you clic on the red 5.00 and hit default you want it to change to original value before the change. As columns can be moved around by users I’m not sure the usefulness of defining columns.
Did you think about using a lookup to the table holding the defaults to return the value?
So, when the button is pushed (trigger OnPush), you need to retrieve the record in the table holding the default values. How are those default values organized? Which fields or fields are in this table key?
Did you even read at least Basic Objects manual? You cannot do anything in Navision (neither in any other language) if don’t understand the difference between a tables and forms.