Name Calculation

[AlanStone]

I am relatively new to FileMaker and have tried to extensively search this issue before posting and could not find an answer! I have a database with 4 tables, People, Companies, Job Orders and Events. I have 2 fields in People, "First Name" and "Last Name" and another calculated field called "Full Name" which is set up as "last name, first name". I am trying to set up a dropdown list to be used in the other tables which will incorporate the "Full Name" setup. I am only able to get one name in the dropdown list even though there are lots of other names in the People table. What am I missing here?

Thanks in advance for your help!

Alan

[Raybaudi]

Hi

1) I think that the calc field is: Last Name & ", " & First Name

2) Go to see if the value list is definited to get "ALL" the values from field People::Full Name

[mr_vodka]

How are you setting up your value list? Are you checking the option for "include only related values" ? If so turn that option off if you want all the names.

[AlanStone]

HI Raybaudi and Mr. Vodka,

Thanks for your responses. I checked to make sure and the value list is set for "all". For some reason only one name is populating the drop down list.

Any other ideas on where to look?

Alan

[Raybaudi]

No other ideas come to my mind ...

Can you post your file ( a clone one ) ?

[AlanStone]

Hi Daniele,

Here is a copy of the file with all the fields redacted.

Thanks again,

Alan

Barnett_Partners_Copy.fp7.zip

Edited April 4, 2008 by Guest

[FestiveEmbalmer]

Had me puzzled, but I got it.

Your calculation for Full Name has the result as Number. Change it to text and it will work.

peace,

matt

[AlanStone]

d'oh! Thanks Matt,

Much appreciated. It works great now!

Alan