AnsweredAssumed Answered

Easiest way to find out the ID number?

Question asked by yuichim on Jul 27, 2011
Latest reply on Jul 27, 2011 by bumper


Easiest way to find out the ID number?


I am trying to find an easiest and simplest way to find a record without performing a "find" in a layout.
For example, if there is a table that has (ID, Name) and you only know the Name to find the ID, how can we achieve it without going to the layout, perform find, set variable with ID.

Is there an alternative to this? 

For example, the SQL has something like:  SELECT "ID" from USERS where Name="John"

Can we do a script like above in FM?

Any help much appreciated...