1 Reply Latest reply on Sep 24, 2014 7:20 PM by hjvanes

    Select Field - obtain corresponding data

    hjvanes

      Hello FM PPL,

       

      Brain freeze atm and need a little help on getting this done. Just forgotten how to do it thats all.

       

      I have 2 tables where Table 2 has all the records in it

       

      Table 1 has 2 fields and table 2 t=has 2 fields

       

       

      Table 1:Name

      Table 1:Age

       

      Table 2:Name

      Table 2:Age

       

      A relationship exists between both tables via id_Constant

       

      Table1:name has a pop-up menu obtauin results from Table2:Name

       

      What I would like to understand again is that when I select a record through the pop-up menu of Table 1:name that it will automatically populate Table1:Age field with the corresponding data of the same name selected in Table2:Age

       

      regards,

      HJ