I would like to display data from three tables on one form but need some help to achieve the desired results.
Table A is to display fields from one record and related Table B will show (as a portal) related records from the table A record. What I would then like to do is display in a third table – related Table C (again as a portal) - is records related to Table B.
However what I would further like to do is to only show records in table C when the user “selects” a record from table B. The records to be shown in table C will be those related to the selected record of table B.
So far my table A and B records are displayed correctly but my table C contains all related records from the displayed table B records.
Is it a question of defining the selection in the portal setup dialog for table C? Although I couldn’t see an obvious calculation to specify records for the chosen table B record.
Is this possible or is there a better alternative?
Many thanks for any help.