Add a Record to a referenced table with the value of the main table.

[Chosk]

Hi Guys, I am trying to add a value to an related table based on the value of the main table.

In another field :

This happens because I am doing an MAX(of the main table ) so obvius, but how can I achiev the same "Raiz" value field of main table, clicking on it, and showing on the related table form?

I am not doing an ref here, just an select on the main table, to return the values of related table.

SELECT(tbl_Relacionados[raiz_sequencial],([raiz] = [_THISROW].[RAIZ]))

[Marc_Dillon]

Not sure if your post makes any sense. Maybe LINKTOFORM()?

[Chosk]

Why it does not make sense? 😞

I didnt understood the point of LINKTOFORM, where can I use it?

Action button?

I tried this way:

LINKTOFORM("tbl_Relacionados_Form", "[raiz_sequencial]", [_THISROW].[RAIZ])

tbl_Relacionados_Form is from related table

[_THISROW].[RAIZ] is the value I want to bring to the related form from the main table.

Maybe if you do some example I can try to copy, not so familiar with LINKs formulas...

[Marc_Dillon · Accepted solution]

---

@Chosk wrote:

LINKTOFORM("tbl_Relacionados_Form", "[raiz_sequencial]", [_THISROW].[RAIZ])

---

LINKTOFORM("tbl_Relacionados_Form", "raiz_sequencial", [RAIZ])

[Chosk]

Tks mate.

❤️