Brian, Yes I am suggesting the drop down on the Event Description but only where the Event Fact is Occupation A drop down list can be popluated dynamically from a query on the existing tables, the query being SELECT distinct tblER.Description FROM tblER WHERE (((tblER.IDET)=47)); with the requisite order by The table solution could be provided by population from the above query on opening the database if response times become an issue. I have used the query approach on many applications where the populated size of the table is low (less than 500,000 rows). As IDET is an indexed field I am sure dynamic drop down list is a valid option. Alan
-----Original Message----- From: Brian/Support [mailto:br...@legacyfamilytree.com] Sent: 11 February 2012 05:13 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] OCCUPATIONS LIST Alan, There is no "Occupation Description" field where your suggestion could be applied. In Legacy Occupation is an event. If you are suggesting that the Event Description field have an autocomplete and drop down list option, that would require a database table be linked to that field. Since Occupation is only one of the many event names in the Event Master List I do not think you can link a database table to the description only when the Event name selected is Occupation and not have it linked for all the other Events. Brian Customer Support Millennia Corporation br...@legacyfamilytree.com http://www.LegacyFamilyTree.com We are changing the world of genealogy! When replying to this message, please include all previous correspondence. Thanks. On 10/02/2012 12:23 PM, Alan Pereira wrote: > Maybe a worthwhile option would be for the Occupation Description field to > display a drop down list of occupations that you have already added such that > as you started to type in the field the list reduced down. This type of > functionality is possible in MSAccess forms so should be just as easy to > produce in Legacy. > > It would allow you to standardise within your own database without affecting > the base functionality of Legacy. > > Alan Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ 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/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ 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