I have a relationship from my Member Table to my Transfer Table. I have created two relatioships where the Mbr_Bond_Number is related to TRN_Bond_Nbr_From and another one where Mbr_Bond_Nbr is related to TRN_Bond_Nbr_To.
When I am creating the report I want to print the Last_Name form the Mbr_Table. The first Time I go to add the field, I get a dialog box for Choose Relationship. See the attachment. How can I get this dialopg box to display again, so the first time, I get the last name from the Mbr_Tbl when the From_Bnd_Nbr is used and then get the Last_Name from the Mbr_Tbl when the TO_Bond_Nbr is used.
If I cannot get to the dialog box, where can I code this to return the field using the appropriate fields.
Thanx in advance.
Jerry