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?
Jonas Möller Nielsen