Solved

Creating a nmae field

Posted on 2006-06-20
6
282 Views
Last Modified: 2010-04-27
I am creating a music databse, but I am not sure what the best way to handle artist name.

In some cases it is a band, but in others it is an individual artist with first and last name.  I want to be able to sort the field alphabetically.  Is the best option to list individuals names LAST, FIRST or is there another way of doing it so it vies FIRST LAST, but sorts by LAST?
0
Comment
Question by:jarrodprice
  • 3
  • 2
6 Comments
 
LVL 19

Expert Comment

by:billmercer
ID: 16950884
The most flexible way would be to store first and last name separately, because that will let you easily sort by either at any time. You could then use a calculated field to concatenate the names together in whatever order you prefer. You could even change the display on the fly.

In the case of artists who go by one name (Bjork, Prince, etc), you can decide whether that goes in the first or last name field, or possibly both.


0
 
LVL 28

Expert Comment

by:lesouef
ID: 16951543
there is no perfect answer, because whatever you do, you'll get exceptions ruining the organisation:
think about these:
Led Zeppelin, should that be ordered by L or Z
Jack de Johnette, should that be ordered by D or J
Al Di Meola, same
Rolling Stones, R or S
...etc, its really the way you remind their name in fact.
I think I would make an auto-enter field created from the last name if you use 2 fields, or the last word of the name if you use only 1, and alter that manually in the rare cases where it would not appear where you'd like it.
0
 
LVL 19

Expert Comment

by:billmercer
ID: 16952776
It gets worse, too.
What about Prince -> the artist formerly known as Prince {funny squggly symbol} -> the artist -> Prince
What about John Cougar -> John Cougar Mellencamp -> John Mellencamp

Here's how I organize my music collection:
If the artist is a group, I alphabetize by the whole group name. Led Zeppelin would be under L.

If the artist is an individual, I use the last name.
If it's an individual with a single name, I use that as the last name.
Tribute albums with multiple artists I put under the artist the tribute is to.
If I buy an album that includes work by an artist who I like, and that's the primary reason I have the album, it will go with that artist. For example, if you're a big Yanni fan (god forbid) and you get a collection that has some of his stuff on it along with other things, you might want to file it under Yanni.
If it's classical or orchestral music, I use the last name of the composer instead.
Soundtracks are ordered by the name of the movie.

Really, it's all a personal decision. If this is a system for yourself, do what you want. If it's something you're creating for someone else, make it as flexible as possible, so anyone who uses it can choose their own preferences.

0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:jarrodprice
ID: 16964742
I am new to Filemaker.  How do I create a calculated field so it displays the name together, but sorts by last name?
0
 
LVL 19

Accepted Solution

by:
billmercer earned 50 total points
ID: 16965693
Store the first and last names in two separate fields, and create a third field, a calculation field, that you define to concatenate the first and last name together, like this:
  FullNameCalc = FirstName & " " & LastName
Then use the last name field to sort your records, but display the calculated field on the layout.
Or, if you're creating a report, you can simply use merge codes to combine the fields in a text box.


0
 
LVL 28

Expert Comment

by:lesouef
ID: 16966635
if he's new to fm, he probably does not know yet what is a merged expression.
in the layout, use a text block as you would do for a label then place in it field information by using <<field-name>>.
this way you can even build complete sentences:
this is the full name of the current user <<firstname>> <<lastname>> and its phone number is <<phonenumber>>.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question