Hi all,
I was wondering if there's a way to combine say a first name and last
name into a database? I wanted to basically add a relational database
in FM, but for some reason when I combine the two fields into one, it
won't list everything I want. Basically I'd love, first name and last
name combined into a full name field, that you can pull down so that
the users can't change a person's name. Then add a company line or put
the companies from the main database in the name selection would be
great too!
Thanks.
-jim

How I Did it:

Create a calculation field called "JoinName"

The calc should be:
LastName & "," & FirstName
or if you prefer...
FirstName & LastName

etc..however you want it organized. for your drop down, you can create
a value list with "JoinName" as the first field and "Company" as the
second.

That's what is usually done :
1) create a 'Companies' table with a unique 'Company_ID' per Company (then
for a given compny, you may have a portal showing the persons belonging to
it - with the relationship below -)
2) in your 'Persons' table:
- create a regular field 'Company_ID', empty, that will be filled by hand
for each person belonging to that company
- create a relationship between 'Persons' and Companies' with as link, the
field 'Company_ID' both sides
- create the fields :
'Full_Name_WOCy' (calc) = Case( IsEmpty(FirstName); LastName; FirstName & "
" & LastName)
'Full_Name_WCy' (calc) = Case( IsEmpty(LastName); "ERROR";
Case( IsEmpty(FirstName) and IsEmpty(Company_ID); LastName; FirstName & " "
& LastName);
Case( IsEmpty(FirstName) and not IsEmpty(Company_ID); LastName & " " &
RelationshipWithCompany::Company_Name; FirstName & " " & LastName & " " &
RelationshipWithCompany::Company_Name))
I didn't check it out, but it should be close.
Of course you may add values lists.
Remi-Noel

<pasg (AT) btconnect (DOT) com> a écrit dans le message de news:
1168351968.082906.235580 (AT) 11g200...oglegroups.com...