Two records from the one table in a single layout. Possible?
For the purpose of example:
I have a table called Songs and a related table called Artists. In the Songs table I have a field called Artist Name and another called Co-Artist Name. In the Artists table I have a related field called Name.
I have a layout which displays details of a Song (from song table) and and I want to display details about the artist from Artist table. This works fine for one artist. But what if one song has an Artist and a Co-Artist? The information about both Artist and Co-artist is in the Artist table, identified by the Name field.
In other words, I want to display two records from the one table in one layout.
Is this possible? Does it mean I have to use a portal?
Thank you in advance