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

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

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.

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

No other ideas come to my mind ...

Can you post your file ( a clone one ) ?

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, 200817 yr by Guest

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

d'oh! Thanks Matt,

Much appreciated. It works great now!

Alan