patthepiper 0 Report post Posted October 12, 2007 Once again I'm chasing my tail and hoping that a cleared head (certainly not mine!) will help. In the main database of my primary project I have just over 50,000 names. Today I attempted to locate a record [#7850 Phoebe Dunbar] and it didn't appear in the picklist. I found the record by Reference Number. However to check TMG I then searched by using both the simple and advanced picklists, and also by running reports. The picklist displayed 9 names The report listed 2 additional names (total 11) Neither included #7850 I ran Validate File Integrity - result no problems, then Optimised. I re-ran reports, rechecked picklists, still no Phoebe. The report I used was List of People, filter 'any given name contains [?]' (I entered 'Phoebe') I modified the filter to 'sex does not include male' and any given name contains [?] - same results I tried filering the picklists, once 'primary names only' . Still no Phoebe. The only observation is that all other results were 5 digit (e.g. #33883, #434410) and the wanted result 4 digit. So what is peventing the picklist from displaying all ID's? More worrying, how can I depend on the fidelity of picklist information and report filtering? Pat Dunbar Share this post Link to post Share on other sites
Terry Reigel 0 Report post Posted October 12, 2007 My guess is that you have "Phoebe" entered in the wrong field in her name tag. Open that tag and see if it's in some field other than Given Name. Share this post Link to post Share on other sites
patthepiper 0 Report post Posted October 15, 2007 Terry, A strange tale follows! As you suggested I checked the Given Name in the Tag Entry panel: it showed "Phoebe". F2 -The Picklist did not show '#1:1750 Phoebe Dunbar' In the Tag Entry I deleted, then re-entered "Phoebe" F2 - The Picklist then showed '#1:1750 Phoebe Dunbar' Problems 1) How many more similar entries are missing from my picklist, and how can I locate them? (Please bear in mind that I had already Re-indexed) 2) Is this a possible problem with this version of TMG? My version is Gold, English, fully updated. Kind regards, Pat Share this post Link to post Share on other sites