Yeah, I guess it was somewhat like thinking out loud lol.
Let me try to rephrase.
I create table A, which has a 1-Many relationship with table B, which has a Many-to-1 relationship to C.
From TableA form, I can create a new item at B.
It will open Table B Form view, where the Ref column will be already
“filled” by the link to Table A.
Is that correct?
Ok. But how do I connect table B to table C?
Does it creates a dropdown list at TableB Form, where I can choose between ALL records from Table C?
What if Table C has a thousand records, and worse, some are equal, since Table C itself is a Many-to-One table to Table D?
(The Label can´t be the Key, so you use the Foreign Key as Label. But Foreign Keys repeat in a One-To-Many)
Anyway, seems like ideal situation would be to enter TableA Form, create new item at TableB but leave empty the relation to Table C.
Then at Table C Form, we should somehow choose that same Table B record already linked to Table A, thus linking C to B, which was already connected to A.
But that seems impossible, as from Table C, the inline table to B will look empty and your only option is to create a NEW record at B, linking B to C, but not being able to connect it to A!!!
Errr… I guess this answer was still too long and complicated