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

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.

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

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.