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.