2 Replies Latest reply on Oct 29, 2016 9:21 PM by brandow

    Formatting <fullname> for both Asian and European clients

    brandow

      I'm building a database where client names are both Asian (LAST/First) and European (First/LAST).  Is there a way to use radio buttons on the data entry page (Asian/European) and create some sort of script that would switch the sequence of the fields LastName and FirstName?  I would like the full name, in the proper order, to appear at the top of the screen and also when printing out reports, etc.  Using a calculation to create <fullname> (whichever sequence), is there a way to keep the formation of the LastName all caps and FirstName upper and lower case? Thank you to all.