Jump to content

Find Albums of compilations by CD OR by composer ?

This topic is 7430 days old. Please don't post here. Open a new topic instead.

Recommended Posts


I would appreciate a solution to this problem please - I have a classical Music database already built in another program and wish to export it to FM 6. But I want to be able to find (preferably with a click on a button) all entries that are on a compilation CD. At the moment all my entries are by composer, so one CD may have 10 different composer records, but all by the same soloist/orchestra.

I would like to click the button to go to a view showing all the entries (i.e., the track list for that CD) and then go back to my layout of Composer/soloist/orchestra etc.

As I also have a unique number field (the actual CD number) then I assume a find by that number would produce just that CD with all the composers listed, but is it possible to have all this in one field or do I have to put up with just a list view. It is obviously neccessary to have two fields present in this listing - Composer and Piece (i.e., Symphony/Concerto for example)

Hope you can provide a nice elegant solution - if this is a lot of work I would be willing to pay a fee - if anyone would like to quote for the design of this - other solutions are needed also !!



Version: v6.x

Platform: Mac OS X Panther

Link to comment
Share on other sites

Hello Madwolfie.

The simplest method to locate all the entries for a given CD woudl be to create a self-join relationship which matches the CDnumber field to itself. The your button could be atatched to the 'Go to Related Record [show]' command, and will extract the track records for the CD.

However if you want the result returned in a special layout or in a single text field (eg formatted into columns etc) then you would require a script which assembles the data from the found records (after the Go to Related Record[ ] step), and presents it appropriately. There are a few ways this can be done, depending on your preferences.

If you'd prefer to have it done for you, I do custom development work, and would be happy to talk to you offline. If you're interested the URL below will take you to our web site, and the contact details are there.

Link to comment
Share on other sites

This topic is 7430 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.