Hi Tom -

Maybe you can give us some background first. What are the two table names? What field in tableA is now being converted to a reference field to tableB? Then we can mock something up.

Here is one way to do it...

https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/is-it-possible-to-link-automatically-via-a-function-fields-in-two-tables-that-contain-the-same-text-5c6aaf80e850ad238982b496?page=4

Lovely progression to some succinct code Sean

for oneRec in select OneTable do
for manyRec in select ManyTable where Text = oneRec.Text do
manyRec.(OneTable := oneRec.Id)
end
end

Dare I say it could even be written as

for oneRec in select OneTable do
for manyRec in select ManyTable where Text = oneRec.Text
manyRec.(OneTable := oneRec.Id)
end

Regards John

Thank you John.

Yes, one can and the formula editor will add the missing "do" and "end"

Regards Sean

Ah Sean you are right I took it from the manual which gives the example

for p in (select Person)
p.Haircolor := "red"

and thought there were two forms, one that looped through one by one and another that did a bulk update but would this do it?

for oneRec in select OneTable do
let manyRec := select ManyTable where Text = oneRec.Text
manyRec.(OneTable := oneRec.Id)
end

Regards John

Yes John, it works in my testing. Nicely done! Now the code is even more succinct.

Regards Sean