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]))
Solved! Go to Solution.
@Chosk wrote:
LINKTOFORM("tbl_Relacionados_Form", "[raiz_sequencial]", [_THISROW].[RAIZ])
LINKTOFORM("tbl_Relacionados_Form", "raiz_sequencial", [RAIZ])
Not sure if your post makes any sense. Maybe LINKTOFORM()?
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...
@Chosk wrote:
LINKTOFORM("tbl_Relacionados_Form", "[raiz_sequencial]", [_THISROW].[RAIZ])
LINKTOFORM("tbl_Relacionados_Form", "raiz_sequencial", [RAIZ])
Tks mate.
❤️
User | Count |
---|---|
42 | |
25 | |
25 | |
17 | |
13 |