a Cry for help. I really don't know how to call it...

[pianoman]

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

Pianoman

(Portugal)

[mr_vodka]

You should have at least 2 tables.

One for the CD information. The other for tracks realted to that CD. Each CD record should have its own RecordID number, and each track record should have the associated RecordID as well.

Then when you want to print a report, you can do a report with columnar list grouped by the RecordID number of the 'Tracks' table.

[sbg2]

Attached is a brief example of how a relational database might be set up for your collection. Im not sure if Filemaker included tutorials but that would be a great place for you to start, also reading through the help files.

CD_Collection.zip