Hallo there!
I have three tables, A, B, C.
TableC has a PK "PK_C".
TableA and tableB both have the PK_C as an FK - "FK_C"
TableB also has a FK (FK_A) which is the PK (PK_A) of tableA.
In tables A and B I have set FK_C to look-up (Visual Editor) in tableC.
In tableB, I am trying to set the default for FK_C by using the value set in tableA (where B.FK_A = A.PK_A).
I have no idea how and where to do this - I assume I set the default in the Visual Editor under the "edit as" menu. However, I need a (big) hint on the code needed.
Rgds
Mandy