1 of 1 people found this helpful
If you want to display records in a list view from two separate tables, then you need to use virtual tables.
Here's a 2-part blog from Soliant on setting up VL.
If you need just the first record from TableB, you can just put related fields on your TableA layout, it will show the data from the first related record. If you need more than one record to show up, you will need to use a portal. However, you can make the portal relatively invisible if you don't want to make it look like a portal, and you can have multiple portals on your layout each starting with a different record number if you don't want your related records to display vertically.
For example, Portal one, go to portal setup, under the Format area, Initial row, set to 1, number of rows, 1. Portal two, using the same relationship, initial row 2, number of rows 1. You can now put the first related record in one spot on your layout, and the 2nd related record in a totally different spot on your layout. Then, use the inspector to make the lines and other elements of the portal to disappear, and there you have it.
Hope this helps you.
Thank you Mike I will take a close look
thanks for your suggestions.
I would like to try avoiding portals because my aim is to show related data inside button bar buttons.
The reason is (beside icons), I can make them autosize when one is empty.