AnsweredAssumed Answered

Select Field - obtain corresponding data

Question asked by hjvanes on Sep 24, 2014
Latest reply on Sep 24, 2014 by 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

Outcomes