1 of 1 people found this helpful
Then you need to create new fields for Last Name and First Name and separate the fields in your import. Either you import all "Names" (both company and person) to one field and then use logic to separate names for Company and Person with a script where you Loop through all imported records
I also suggest that you read the free FileMaker Training Series
I suggest something along the following lines:
1. If they don't already exist, create these fields: firstName, lastName, companyName. These are simply text fields.
2. Create a calculation field called, say, clientName and use a calculation formula that selects companyName if it exists, otherwise uses first and last names, thus—
If ( not IsEmpty ( companyName ) ; companyName ; firstName & " " & lastName )
This calc tests to see if there is a company name; if there is, it uses it; if there is not, it uses first and last name separated by a space.
3. Wherever company name currently appears on your layouts, replace it with this clientName field.
I'd define a calculated cNameFull field since this will be needed in multiple places.
And here is a variation on IsEmpty( ):
GetValue ( List ( company ; cNameFull ) ; 1 )