Good afternoon.
Let me see if I can resume the thing.
I have a table DESENHO with ID_desenho (primary key) and NOME_DESENHO.
It as two 1>many relations to another table, CONJUNTO_DESENHOS, ID_DESENHO_CONJUNTO (primary key) and ID_FILHOS.
The goal is that the table CONJUNTO_DESENHOS store an Assembly drawing, and the small pieces (drawings also) that are used to make the Big drawing.
I have a Form with a MainForm with Content (DESENHO), in witch I make a filter to show just the Assembly drawing for populate with small drawings (Link master fields>“ID_DESENHO”; Link slave fields>“ID_CONJUNTO_PAI”).
I have a SubForm with Content (CONJUNTO_DESENHOS) with a Table control that I use to populate the chosen Assembly drawing.
In that Table control, I have one column (JUST_NAME) that is not part of (CONJUNTO_DESENHOS), so the Data field is empty.
My question is:
In that possible to read the value form ID_FILHOS (that is linked to table DESENHO) and from that table get the associated NOME_DESENHO, and write it to JUST_NAME, as a read only value?
Hope i’ts not to confuse!
Thank you very much!!