This could be calculated - but what is your purpose here? Do you need to export the data in a specific format?
Yes, for the sake of simplicity I wrote that I need a text file. Going into detail I actually need to export the data in xml format (not a big issue there, just need to include values into tags). My problem is combining values from related records into a single field.
Filemaker can export in XML format and - during the export - apply a XSLT stylesheet to transform the data into any XML schema (as well as text and HTML).
I have tried that route but doesn't really work for me (or is beyond my knowledge).
If you could show me how to proceed with a simple calculation to merge values from different fields I would appreciate, also because I need the learn the same technique for other purposes. Also need to create a simple text file for Album credits for example.
If you define a calculation field in the Tracks table as
TrackNum & "(" & Performer & ", " & Title & ", " & Time & ")"
AlbumTitle & "(" & CatalogNum & "): " & Substitute ( List ( Tracks::cLine ) ; ¶ ; "; " )
Thank you very much, I have applied this to my solution and it is already working the way I intended!