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

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.

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.