Update Field Value based on Field No.

rickyl76

I have items that are related to each other and depending on which fields are updated then the information on the related items must be updated also. The related items don't need to be completely in sync, just certain fields. After an item has been modified I check to see what has changed and then store in a temporary record the field no. that changed and the new field value. From this how can I update the correct field value in the related item record bearing in mind I just know the field no. that needs to change?

Kishorm

You need to use RecordRef and FieldRef variables. You use RecordRef to get a reference to the record you want to work with and the FIELD property to get a FieldRef variable which references the field that you want to work with for the record. You can then use the VALUE property of the FieldRef to read/write the field value.

See the following links for some for info...

https://msdn.microsoft.com/en-us/library/dd355050(v=nav.90).aspx
https://msdn.microsoft.com/en-us/library/dd301382(v=nav.90).aspx
archerpoint.com/blog/Posts/journey-mystery-working-recordref-variables-dynamics-nav