Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Business Productivity Kit

Business Productivity Kit

Business Productivity Kit

Hi I have a database setup it is just a edited version of the Business Productivity Kit. What happens is when I add a contact lets say John Murphy everything works fine. But in this database I need to add maybe five or six different John Murphy's with different address's. When I go to sales orders and lookup John Murphy it only shows one John Murphy even though there are 6 in the contacs. Any ideas how I can show all 6 John Murphy's??????

RE: Business Productivity Kit


I don't use the Business Productivity Kit myself but I do have a copy of it and I think I know what the problem is.

The drop down list only shows unique values.  Since John Murphy occurs more than once it only show the first entry from the contacts database.

Just curious, how would you know which one to choose if their names are exactly the same yet they are different people?


RE: Business Productivity Kit

When in contacts if i do a search for john murphy and click find it will brings me to list view with all john murphy's listed and I can see the address's. I was hoping to do something like that in sales orders or if you have a better way to do this please let me know??

RE: Business Productivity Kit

You might try this.  In the Contacts module you could change the "Full Name" field from this calculation:

First Name & " " & Last Name

To this calculation:

First Name & " " & Last Name & " (" & City 1 & ")"

This should make all "John Murphys" appear on the list as long as they have different cities.  If you have two or more in the same city then you're back in the same situation again.  You could also use a field other than city like maybe phone number or company name if that makes more sense for you.

At this point I should wave the caution flag because making this change *may* have unintended consequences.  Since I'm not familiar with the "BPK" it's dificult for me to know exactly what the full implications are without analyzing the entire system which would take some time.  I don't *think* it would be disasterous to go ahead and try the change because you could revert back to the original calculation.

Hope this helps.


RE: Business Productivity Kit

Thanks very much TStriker that works but when I print an invoice it show city after the name

RE: Business Productivity Kit

Yeah, that would fit the "unintended consequences" concern quite nicely.

My first thought is to 'essentially' recreate the original field but use a different field name.  Maybe something like 'Last First Only' and make the calculation exactly like the original calculation.  Then change your printed report so that it uses the newly created field rather than the original field.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close