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

--

Reply via email to