Hello,
Noobs here. I am looking for some assistance that when I select a record on a form I am taken to that record. Example below.
I am taking this simplified hypothetical example in the parts table with columns: Finished, Shared1, Shared2, Shared3
Row 1 values: A, B, C, D
Row 2 values: B, A, C, D
When Row 1 loads in the layout you sent, say that A appears on the upper right box. Therefore B,C, D load in the bottom in red
Desired behavior: when B is then clicked, you want it to replace A in the upper right box and have A, C, D appear in the bottom in red.
Thanks in advance,
Brett