Alpha Video Training
Results 1 to 4 of 4

Thread: Combining Names in Fields

  1. #1
    Member wlk8791's Avatar
    Real Name
    Kristie West
    Join Date
    Sep 2009
    Location
    Hattiesburg, MS
    Posts
    71

    Default Combining Names in Fields

    I want to have a field that combines the following fields:

    First Name
    Last Name
    Company Name

    I created the Name field that I want to display First and Last Names OR Company Names. I 've tried using .AND. .OR. and +, but I'm doing it wrong.

  2. #2
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    6,024

    Default Re: Combining Names in Fields

    Code:
     
    alltrim(fname) + " "+ alltrim(lname) + " "+ alltrim(Cname)
     
    or
     
    if(isblank("lname"),cname,alltrim(fname) + " "+ alltrim(lname))
     
    or 
     
    if(isblank("cname"),alltrim(fname) + " "+ alltrim(lname),cname)
    That help? There are other methods, but you did not say just how far you want to take it.


    .
    Dave Mason
    dave@aldausa.com
    Skype is dave.mason46

  3. #3
    Member wlk8791's Avatar
    Real Name
    Kristie West
    Join Date
    Sep 2009
    Location
    Hattiesburg, MS
    Posts
    71

    Default Re: Combining Names in Fields

    I'm embedding a browse. Instead of showing separate columns for each, I wanted to combine them into just a name field.

  4. #4
    "Certified" Alphaholic DaveM's Avatar
    Real Name
    Dave Mason
    Join Date
    Jul 2000
    Location
    Hudson, FL
    Posts
    6,024

    Default Re: Combining Names in Fields

    I do that with the code I sent you. There are three seperate pieces of code depending what you wish it to look like.

    In a form, make a calculated field combnmes = whichever code you want from above

    Put this in your embedded browse instead of the three collums

    Make sense?
    Dave Mason
    dave@aldausa.com
    Skype is dave.mason46

Similar Threads

  1. Combining 4 Dates fields into one Search??
    By Scholin in forum Application Server Version 8
    Replies: 2
    Last Post: 08-06-2008, 06:32 PM
  2. Combining words/fields from two tables
    By Jim Gatton in forum Alpha Five Version 5
    Replies: 4
    Last Post: 01-20-2005, 06:25 AM
  3. Combining two name fields
    By gwesley2000 in forum Alpha Five Version 5
    Replies: 4
    Last Post: 02-08-2003, 08:05 AM
  4. Combining fields into a calculated field
    By GregOnline in forum Alpha Five Version 4
    Replies: 2
    Last Post: 04-26-2002, 12:44 PM
  5. combining fields
    By John E Schultz in forum Alpha Four Version 6 and Prior
    Replies: 7
    Last Post: 03-08-2002, 06:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •