Calculation field to display specific record

[hartmut]

Hello. Is it possible to use a calculation field to display a certain record?

For example. A calculation field named "display"

Would have a calculation to display the contents from record 29 from the field "product" in another table named "inventory". What wouldsuch a calculation be? Happy new year

[comment]

The GetNthRecord() function could be used for this - though a lot depends on what you mean by "record 29". Filemaker will consider a record to be #29 if there are 28 records preceding it in the current found/related set, according to the current sort order. That can change very quickly, so perhaps you should reconsider your strategy towards whatever it is you're trying to achieve.

[ericmurphy]

Would it help to identify each record in the table by a unique serial number? You could auto-enter the S/N, and then each record has a unique identity. It shouldn't be too hard to get a calculation field to determine the correct field based on S/N.