Jump to content


FileMaker Inc. has a deadline for users of version 10,11, 12 as Individual box or volume licenses (with expired maintenance).
If you don't renew your maintenance and upgrade to FMP 13 you will no longer be eligible to upgrade, at the discount pricing.

Volume Licensing upgrade pricing for FileMaker Pro 13, FileMaker Pro 13 Advanced and FileMaker Server 13 will be discontinued.
Individual upgrade pricing for FileMaker Pro 13 and FileMaker Pro 13 Advanced will increase after September 26, 2014.
As of 27-September-2014, FileMaker 10 products will no longer be available for purchase or support.



Client List for Invoicing

  • Please log in to reply
2 replies to this topic

#1 tangential  newbie

  • Newbies
  • PipPip
  • 2 posts
  • FM Application:11
  • Platform:Mac OS X Lion
  • Skill Level:Beginner

Posted 14 February 2012 - 11:38 AM

I'm new to Filemaker, so forgive me if my terminology is a bit inaccurate. I'm using FMP 11.

I'm creating an invoicing database and having some issues with populating the client list dropdown. I used the "Invoices" starter solution as a base.

That's the background, on to the question. The client list is populated from the customer database and the list is constructed using the first and last name fields or the company name if no individual is identified. I believe the string looked like this:

First Name & " " & Last Name.

I wanted to display last names first, so I changed that string to:
Last Name & ", " & First Name

Which worked, except now the company names are displaying with the ", " also. ex. John Smith displays correctly as "Smith, John" but ABC Corp displays as ", ABC Corp" This tells me that the company field is replacing the absent first name field. My question is how do I get it to replace the Last Name field instead so that I can get rid of the ", " on the company names? Also, If I'm successful at relating the company name to the last name, is my list going to populate with "ABC Corp, " instead (because of the above string)?

Thanks in advance.
  • 0

#2 dansmith65  veteran

  • Members
  • 858 posts
  • LocationB.C. Canada
  • Certification:8, 11, 12, 13
  • Membership:TechNet
  • Time Online: 15d 2h 11m 18s

Posted 14 February 2012 - 11:56 AM

It sounds to me like you are entering the Company name into the first name field. I just checked out the Invoices start solution and it has a separate field for Company.
  • 0

#3 tangential  newbie

  • Newbies
  • PipPip
  • 2 posts
  • FM Application:11
  • Platform:Mac OS X Lion
  • Skill Level:Beginner

Posted 14 February 2012 - 01:03 PM

No, I am sure its not a simple "data integrity" issue. I imported the fields from excel, perhaps something got messed up in the import. I'll delete the records and re-import.
Thanks for the reply.
  • 0

FMForum Advertisers