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...