Value list only shows 3 values!!

[mfuenzalida]

Hi, this is my problem, I hope someone can help me out. I have the "Customers" database which contains basic info of my customers including "Last Name" and "First Name" and a calculated field "Full name" which is = "First name" & " " & "Last Name". So far no problems. I have other database called "Visits" to record every visit to my customers. In that database I have a field "Customer" and in the form I choose to have a pop up list to select the customer's name from the "Full Name" field in the "Customers" db. Now, here's the problem: from 60 available customers the pop up list only shows 3!!! What am I doing wrong? Please, any help would be very welcome.

Thanks

[danjacoby]

Are you setting the value list to show all the values, or just related values?

Or are there duplicate customers? Duplicates will only show up once in the value list.

[mfuenzalida]

I found my mistake: the calculated value of "Full Name" was stored as a Number instead of Text. How dumb is that!!!??

[danjacoby]

Not dumb -- for some reason, Filemaker defaults to Number for all calcs and globals. Don't know about others, but most of my calcs & globals are text, so it's a royal pain.