I would like to link to a linked field on a table so that on the third table, the list presented is a subset of the records in the context of the second table. That probably makes no sense so I’ll try to sketch it out:
Table A A Record1 A Record2 A Record3 A Record4 A Record5 A Record6 A Record7
Table B B Record1 linked to: A Record2 A Record5 A Record6 A Record7 B Record2 linked to: A Record3 A Record5
Table C C Record1 linked to: B Record1
What I would like to create on table C is a column that links to Table A in the context of Table B. So that if I want a link to Table A in the context of Table B, I’m only shown the corresponding records from Table A as selection choices, rather than ALL records from Table A.
In the example above, linking C Record1 to B Record1, the link to linked field on table C would only list A Record2, A Record5, A Record6, A Record7 instead of the entire contents of Table A.
Is this possible today or is this only available as a feature request?