Sign in to follow this  
Followers 0

Client List for Invoicing

3 posts in this topic

Posted

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

Share this post


Link to post
Share on other sites

Posted

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.

Share this post


Link to post
Share on other sites

Posted

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.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  
Followers 0