Rowselection --> Display other table field info

To display a content of a field bellow a table I use

ROW Selection of Table_xxxxxx
EDT_XXX=Table_Flugplatz.COL_XXX[Table_Flugplatz]

How can I display a field info from another table (in my case the "Notes" field?
See screen shot!

Thanks for any advice!

Hello Hans60,

I asume it's a filetable.
Then you can link the edit-control to the Note-field and just use HFileToScreen().

HTH.

Thanks Louise!
I am using V12. It displays the info of the field info but does not filter according the selected row in the table above....

I think that you have to do one hreadseek and then EDT_XXX=note.note in the row selection of the main table.

If you have more than one note per main record or want to use one table with only one
line/column you can just use the ..filter property of the second table.

I always use the first solution, two more lines of code but much faster.

Hi Hans,

insert a invisible column "col_note" in your table.

In RowSelection of your table type:


edt_note=col_note

Hello.
In the tab link of the edit control properties select Multifile option.
In BaseFile select the file FlugPlatz and the item FlugPlatzID.
Click on symbol to link to another table. In linkedfile select Note, the item to link, select FlugPlatzID and in the list below select Note. Validate.
In the Row Selection Code of the table enter this:
FileToScreen()
Taste now.
Sorry for my bad english, i hope you undesrtand my instructions.
Regards

Message forwarded from pcsoft.us.windev

Thanks about the hints!
The multy file I have even never looked at.

Regards
Hans