Get selected field value

[#1]

Hello,

I have this table:

Header 1	Header 2	Header 3
A 10	D 9	F 3
M 6	E 3	R 3
S 2	K 1	P 6

When I clicked on one filed I want the selection will be on filed XXXXX with current field value.

For example: if I clicked on R&Chr(10)&3 Filed (row 2, column 3) I want the selection will be on filed XXXXX with the value R.

Thank you!

[swuehl · Accepted solution]

Not sure if I understood correctly, I can't see field XXXXX in above table. I assume it does exist in your data model and it shows field values as needed (i.e. 'R').

You can try a On Select field event trigger (on tab triggers in Settings - Document properties),with a Selection - Select in field action.

Use XXXXX as Field and a search string like

='('&left([Header 3],1) &')'