Perform Find Parameters

[revjj]

I would like to do a find for only one record using the Get  ( Record Number ) function without having to pop the record number into a field.

Any Thoughts?

 

[Ocean West]

a script would be ideal. 

or show all records omit the record you are on then show omitted records, you will have a found set of 1. 

[comment]

3 hours ago, revjj said:

I would like to do a find for only one record using the Get  ( Record Number ) function without having to pop the record number into a field.

That is not possible: only data in fields can be used for find.

Also keep in mind that the Get ( RecordNumber ) function returns the record’s position in the current found set, while a find searches all records (unless you're using the Constrain Found Set command).

 

[LaRetta]

Hopefully, you have a meaningless unique ID in each table which *is* a field and meets the requirements Comment mentions.  You can capture that field value into script parameter, go elsewhere and perform your search for it.  But as Stephen suggested, if searching same table where you are, you can isolate the current record instead. 

As always, having a bit of context really helps us provide better answers. 😁