AnsweredAssumed Answered

Two records from the one table in a single layout. Possible?

Question asked by WillPeart on Mar 12, 2012
Latest reply on Mar 15, 2012 by WillPeart

Title

Two records from the one table in a single layout. Possible?

Post

 

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

Outcomes