No matter what I try, Airtable will not allow me to display a latest linked record in the primary field. All attempts end with circular reference errors. Table structure:

Company

name < primary, formula > ( {current name} )

company names [1:n] < linked > related to Company Name

current name < conditional lookup > from {company names} ( {if latest} = 1 )

...

Company Name

name < text >

company [n:1] < linked field > related to Company

if latest < formula > ( IF {start date} = {latest start date}, TRUE() )

...

I’m running out of ideas. As soon as I use company names in conditional context with if latest, I don’t get the value into the primary field. It also doesn’t matter if I evaluate current name in the Company table as shown in the example or in the Company Name table and use a normal unconditional lookup.

It can’t be that you have to use an automation for such a trivial thing!?

I would be happy if someone knows a solution.