AnsweredAssumed Answered

Search in one field and replace data in another field

Question asked by jonasmn on Mar 22, 2018
Latest reply on Mar 31, 2018 by jonasmn

I have a table with the field "Name" and another field "IDf_Name". The field "Name" is contains names and the "IDf_Name" is empty because it has just been created. In table view, I want to search all posts where the field "Name" equals a certain name, for instance "Jonas" and when such a post has been found, enter the number "1" in the field "IDf_Name". (I want to make a reference with another table that contains the names, instead of having them hard coded in each post.)

 

The above can easily be done in most other programs, spread sheets etc., but how do I acomplish this in FM Pro?

 

 

Regards

Jonas Möller Nielsen

Sweden

Outcomes