Thank you for your post.
Your example is a little confusing, but it appears that FileMaker Pro can accomplish what you want.
You can create fields as follows:
Year of Release
Category (which you can set up to be a drop down list with the five different categories).
I'm not sure what you want to do with the "A000000" information. If you are looking for a way to increment (A000001, A000002, etc.), this can be accomplished using FileMaker Pro.
If you have a specific example, I'd be happy to help you further.
Hello, thanks for your quick reply and sorry for my late one !!
I have more than 100.000 mp3 files to categorise, and I need to find them back easy by keywords.
I'll make all the files like this:
Artist - Title=A000000000X.mp3
so I have:
Britney Spears - Circus=A000000000X.mp3
Barry White - My Love=A00000000X.mp3
ABBA - Mamma Mia=A000000000X.mp3
All my songs are ripped like this.
The A00000000X is a unique ID number for each mp3, so every song get's his own ID number.
Is it possible that Filemaker Pro changes the A000000000X for a new file ID number ??
In my database file I need to say:
Year of Release
LanguageCategory (more categories need to be possible,) In total I have 56 categories, so far.
I have special created software to play MP3 and videoclips, so if i click ont the categorie Rock, it's plays Rock, and If I want Jazz it plays the Jazz files.
I hope me request is more clearly.
I'm an expert in audio-visuel equipement and music management, and now I work to much "old school" so I really need to get my songs recategorised with a database. But I don't have any database skills to create such a file.
I hope you can help me better now with this info.
Thank you for the clarification. Yes, this does help make things clearer.
Yes, FileMaker Pro can assign a unique ID number to each record. When you define the ID field, click "Options..." and a number of options are presented to you. Click on the "Auto-Enter" tab (if not already selected) and check the option "Serial number". Leave it set to Generate "on creation" and set the "next value" to A0000000001, and "increment by" 1. Click OK.
Now, whenever you add a new record, a new ID number is created.
This should get you pointed in the right direction.
Let me know if you need clarification for any of the above steps.
My software programmer told me that the software we use probably can't communicate with with filemaker Pro,
He wants an MS Acces database ?? I didn't really understand why. So is it possible to export the database into another format, just to make it communicate with our software on our machines ?
Both Filemaker and MS Access can export to and import from tab separated (.tab), comma separated (.csv) and excel (.xls) files. You should be able to move data from one to the other fairly easily.
"My software programmer told me that the software we use probably can't communicate with with filemaker Pro,"
I'd double check that claim carefully. He may or may not know what he's talking about.