I have created a form to display a parent record child records from three different tables, but only the first child record displays correctly. Any ideas of why the other two child tables won’t display?
I have defined a set with one parent table and three children tables: Person and Address, Telephone, and eAddress, respectively.
A one to many relationship is defined between the parent and each child.
Each of my child tables has a logical field “Default_indicator”, and one record in each child table has the indicator set to True. The Child tables in the set all are filtered for Default_indicator = True.
When I create a A5V9 default form with embedded browses, all records are correctly displayed as shown below. Note that while multiple records for each child table exist for the parent, only one record, flagged as default, is displayed. So far, so good.
When I create a custom form and display these same fields as type-in fields, I get the unexpected results below.
The parent record and the default child address record is displayed, but the default child telephone and default child eAddress records are not displayed.
Note that the cursor is on the field for telephone type above. Even when this field gets the focus, the desired record is not displayed.
Now, I type in just one letter in that field, and surprise, surprise, both the telephone type and telephone number are displayed, as shown in the third screen print.
I typed in “a” in the telephone type, and both Office and the phone number were displayed. When I placed the cursor on the eAddress type field, the Email was displayed. When I placed the curson on the Eaddress field the [email protected] address was displayed.
Anyone have any ideas of why all three children records won't display at the same time?
Thanks,
Bob McGaffic
Pittsburgh
I have defined a set with one parent table and three children tables: Person and Address, Telephone, and eAddress, respectively.
A one to many relationship is defined between the parent and each child.
Each of my child tables has a logical field “Default_indicator”, and one record in each child table has the indicator set to True. The Child tables in the set all are filtered for Default_indicator = True.
When I create a A5V9 default form with embedded browses, all records are correctly displayed as shown below. Note that while multiple records for each child table exist for the parent, only one record, flagged as default, is displayed. So far, so good.
When I create a custom form and display these same fields as type-in fields, I get the unexpected results below.
The parent record and the default child address record is displayed, but the default child telephone and default child eAddress records are not displayed.
Note that the cursor is on the field for telephone type above. Even when this field gets the focus, the desired record is not displayed.
Now, I type in just one letter in that field, and surprise, surprise, both the telephone type and telephone number are displayed, as shown in the third screen print.
I typed in “a” in the telephone type, and both Office and the phone number were displayed. When I placed the cursor on the eAddress type field, the Email was displayed. When I placed the curson on the Eaddress field the [email protected] address was displayed.
Anyone have any ideas of why all three children records won't display at the same time?
Thanks,
Bob McGaffic
Pittsburgh
Comment