Viewing data from one table in the layout of another table
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
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.