FM6: List contents of multiple related records in single field?

[mehronx]

I'm trying to create a field that displays contents from multiple related records. Is this possible? This is the specific instance:

I currently have a 'song' database. Each song is a record with additional fields for album title, genre, explicit content, composer, etc.

In a separate 'album' database, I would like to create a field that lists all the songs from the album (based on a relationship matched on album title).

Is this possible? Or am I going about this in the wrong way?

I can create a value list that gives such a list, but I don't know how to make such a field.

Edited November 11, 2005 by Guest

[mr_vodka]

I think that you should have two different tables or files (if you are using FM6), one for albums and the other for songs. Each album should have its own uniqID, and each song would have a matching keyID for the album.

Then you can use a portal etc to show all the songs related to each album as you scroll through your album records.

Just a suggestion...

[mehronx]

Wow... I just needed to make a portal. I don't know why that slipped my mind!

Also, thanks for the suggestion.

[mr_vodka]

Just as a side note, I would use some kind of uniqID as the relationship key rather than the album title just in case album titles are the same for different artists.