Get(ReecordID)

[Robert Schaub]

I am set a variable to Get(ReecordID), Later I want to return the that record. The recordID could be 28700 in a set of records that only has 1000 in show all mode. I can't use Go To Record (By Calculation) Get(ReecordID) or By the variable. The number is too high. Anyone know how to navigate to a record by RecordID?

[Genx]

RecordId won't work - its an internal record identifier for filemaker and very rarely has a purpose. Use Get(RecordNumber). If you're really desperate to use RecordId the only thing you could really do would be loop through all the available records until you hit the desired rec id.

[Robert Schaub]

Thanks I have been using Get(RecordNumber), I works good, except when I GTRR SRRO the record number could be 937. But SRRO makes it 1 or the record number in the found set of related. If I turn of the SRRO option it could mess up reports.

[Genx]

What's SRRO in this case?

[Vaughan]

SRRO = show related records only?

[IdealData]

Well spotted Vaughan - another bloody acronym to remember.