Sherry, is that field linked relationally to any other in the database?
Alan From: Sherry/Support [mailto:[email protected]] Sent: 29 November 2014 16:36 To: [email protected] Subject: Re: [LegacyUG] UserID The User ID field holds about 50 characters. I was just giving a simplified example. Sincerely, Sherry Technical Support Legacy Family Tree On Sat, Nov 29, 2014 at 7:16 AM, Gerald E Boor <[email protected]> wrote: If it is meant to be a three digit field, wouldn't you have to start with 001 instead of 01? ...Jerry On November 29, 2014, at 09:04, Sherry/Support <[email protected]> wrote: Alan, It's an alpha-numeric field and that's how that type of field sorts. If you put zeros in front of the numbers so they're all the same length, they'll sort correctly. 01 015 031 205 Sincerely, Sherry Technical Support Legacy Family Tree Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
