Hi all. Please be gentle...this is my first post...
First of all, I apologize if this isn't the right place for this question, but I couldn't find a more suitable place.
But let me (try to) explain:
I have all my classical music cd's in filemaker. I make a record for each piece that a cd contains and I give a number to each CD. Example: CD nº200 has 3 pieces: no.1, no.2 and no.3.
The CD also has a name: example: "Mozart - complete piano sonatas". In that way, I have a record for piece No.1 (with several details like tracks, date, durations, etc) and another for piece no.2, no.3 and so on.
Now...I want to produce a report that is able to recognize that those pieces belong to the SAME CD (no.200) and present every information that is related to that CD: number (200), Label, date, total duration, total no. of tracks, maybe some artist(s), etc.
In short: I think I want to know how to make filemaker recognize all the pieces of a CD (they are in seperate records) and "combine" them all in a report, gruped by CD.
How can I do that?
Many thanks in advance