I have a table with a {Product} field, which is a single linked record to the Products table. I wanted to also add the Product’s ID as a new field. But the RECORD_ID() formula doesn’t accept any arguments – it just outputs the current record’s ID.
I’d like to be able to pass the {Product} field to that formula, rather than having to create a new field in the Products table which I then access via a new lookup field.
This would cut down on the number of “utility” fields I have to create.
