You didn't say which version, but, I wonder if it is possible that the
total number of characters in the field you are displaying has
anything to do with the problem. A drop down list with 1800 plus
records seems a bit unwieldily to me.
Jens
On Oct 27, 2008, at 6:54 PM, Lee wrote:
I've just modified the field to use the 'Pop up menu' instead of the
'Drop down menu'and it shows all names including the ones after 'W'
so its only the drop down option that seems to have this restriction
Lee wrote:
sorry it doesn't matter if the solution is running on a PC or mac
the result is the same. FM 8.5
Lee
Lee wrote:
Hi,
I have a problem that I've never seen before. The drop down list
on an invoice will display fields from another file. In this case
the client's 'ID number' and their name (second field). sorted by
the second field, the client's last name.
Its always been a standard feature however one of my solutions has
decided to only show client's names to 'W' other client's with
last names starting with letters after 'W' will not appear on the
drop down list. Names like 'Young' etc. There are only 1825 names
in the client file and other solutions have in excess of 3000 that
do not experience this problem.
The same drop down list was created in the client file and it also
only shows client's last names alphabetically to 'W'
If the 'sort' is modified to be by the first field, the ID number,
then all client's will be displayed, its only when the sort is by
the second field, the last name that it will only display all last
names up to 'W' and no further
I'm mystified, any clues please
Lee
--
Jens Selvig
...Lost in Montana...
