AnsweredAssumed Answered

Viewing data from one table in the layout of another table

Question asked by nealt on Jan 18, 2013
Latest reply on Jan 22, 2013 by nealt

Title

Viewing data from one table in the layout of another table

Post

      

     I have a db with two tables A and B. They have two related fields Paddle no. and name as well as other fields. Table B has a list of names with their paddle no. When I browse records with a layout using table A I want to display the name corresponding to a paddle no from table B in the layout header. 

      

     I’ve tried all types of perform find, set fields, etc but all I get is a blank. 

      

     Basically what I want to take a field found in table A and use it to get the data from the corresponding related field in table B.

      

     Table A             Table B

     Name                 Name

     Paddle no           Paddle no

      

     I use a custom dialog box to to get A::Paddle no.

      

     I want to get B::Name corresponding to A::Paddle no.

      

     Any ideas?

Outcomes