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
--