2 replies to this topic

[tangential]

Hello,
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.
-Tangential

[dansmith65]

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.

[tangential]

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.