1 2 Previous Next 22 Replies Latest reply on Jan 22, 2013 2:10 PM by nealt

    Viewing data from one table in the layout of another table

    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?

        1 2 Previous Next