0

How to get the value from an external table by clicking on a view

Hello,
I would like to know how to get the value of a textfield into a form from a record of a non linked table. In the fist table’s form the second one is displayed in a view with 2 columns . I would like when I click on a line of the view (external table) put the text of the field of de pointed record in a text field of the first table.

table 1 : 1 record, 2 fields : table2view, Saisie
table 2 : 125 records, 3 fields : SousType, Intitulé, inextenso 
How to ---> saisie := table2.inextenso of the clicked line in table2view

thanks a lot !!!!

Marc

4 replies

null
    • Marc_Di_Francia
    • 4 yrs ago
    • Reported - view

    So, another strategy maybe,

    thank you,

    Marc

    • Sean
    • 4 yrs ago
    • Reported - view

    I would say use a linked table. If you click on a row in a View it will popup that record, but there isn't a way to determine the record information from Table 1 so you wouldn't know which record to copy "inextenso" to.

    • Marc_Di_Francia
    • 4 yrs ago
    • Reported - view

    I got a strategy !!

    • Marc_Di_Francia
    • 4 yrs ago
    • Reported - view

    So i created a link 1 to N between table2 to table1. When click on table1.table2 appears the list wich Is filtered and regrouped on table2.'sous type'. When click on the choosed Line, it affects table1.table2 := table2.Id and then on table1.table2 modif trigger,
    Table1.saisie := table2.'in extenso'
    Table1.table2 := Null

    👌

    marc

Content aside

  • 4 yrs agoLast active
  • 4Replies
  • 1275Views