Search Record Based On Field Selection

[bmarcowka]

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

 

[Steve Martino]

It would help if you used real names for your fields and real data in your example.

[Fitch]

Not completely clear what you've got going there, but based on your first statement "when I select a record on a form I am taken to that record"...

You could create a script like:

Enter Find Mode
Set Field[ finished part ; Get(ScriptParameter) ]
Perform Find

You would then call this script with buttons -- the fields can be defined as buttons if desired -- and in the button setup you specify the field's value as the parameter.

Hope that helps, welcome to the forums!

[Lee Smith]

Hello Brett,

Please read my email to you.

TIA

LEE

[bmarcowka]

Done.  Thanks Lee