RE: [LegacyUG] OCCUPATIONS LIST
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
RE: [LegacyUG] OCCUPATIONS LIST
Hi Mike I avoid using both the Title fields as these influence how a person is displayed, preferring to add title as an event. Occupation can change over time - I spent half my working life as a mechanical engineer and the other half as a systems analyst. Some of my ancestors changed occupation as many as 6 times. The Event Occupation handles this very well. Alan -Original Message- From: Mike Bridgeford [mailto:mikebridgef...@gmail.com] Sent: 11 February 2012 06:40 To: LegacyUserGroup@LegacyUsers.com Subject: RE: [LegacyUG] OCCUPATIONS LIST Hi Alan, I use the 'title suf', after the person's name to record the person's main occupation in square brackets. For example, mine would be Michael Angus Bridgeford [mech.engineer]. It may not be sortable, but it give me a very quick and ready guide to a person's main occupation, which helps with the identification of other information relevant to him. I do not normally put in the female's occupation, unless it is relevant. Regards, Mike bridgeford -Original Message- From: Brian/Support [mailto:br...@legacyfamilytree.com] Sent: 11 February 2012 07:13 AM 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 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
Re: [LegacyUG] OCCUPATIONS LIST
Alan, Whilst that may well work for you, it will not work for me because (a) I do not have an IDER value of 47, and (b) the way I use that Events is clearly very different to that used by yourself. In other words, for many (most?) people it will give totally stupid result. I cannot think of anyway of doing this where the method of using a function is at the discretion of the user. Ron Ferguson http://www.fergys.co.uk/ -Original Message- From: Alan Pereira Sent: Saturday, February 11, 2012 11:27 AM To: LegacyUserGroup@LegacyUsers.com Subject: RE: [LegacyUG] OCCUPATIONS LIST 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
RE: [LegacyUG] OCCUPATIONS LIST
Ron, you have answered your own comment. If you do not use the event Fact occupation then you will not have an IDET=47. This drop down list will, for you, not occur. This is exactly what I meant by it being at the discretion of the user. If you use it, then it populates with values you have previously used. This you can add to with a new value or use again so as to standardise your Occupation description. Alan -Original Message- From: Ron Ferguson [mailto:ronfergy@tiscali.co.uk] Sent: 11 February 2012 12:57 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] OCCUPATIONS LIST Alan, Whilst that may well work for you, it will not work for me because (a) I do not have an IDER value of 47, and (b) the way I use that Events is clearly very different to that used by yourself. In other words, for many (most?) people it will give totally stupid result. I cannot think of anyway of doing this where the method of using a function is at the discretion of the user. Ron Ferguson http://www.fergys.co.uk/ -Original Message- From: Alan Pereira Sent: Saturday, February 11, 2012 11:27 AM To: LegacyUserGroup@LegacyUsers.com Subject: RE: [LegacyUG] OCCUPATIONS LIST 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
Re: [LegacyUG] OCCUPATIONS LIST
Alan, I do have an Event/Fact Occupation. However its IDET has a value of 51. Ron Ferguson http://www.fergys.co.uk/ -Original Message- From: Alan Pereira Sent: Saturday, February 11, 2012 1:19 PM To: LegacyUserGroup@LegacyUsers.com Subject: RE: [LegacyUG] OCCUPATIONS LIST Ron, you have answered your own comment. If you do not use the event Fact occupation then you will not have an IDET=47. This drop down list will, for you, not occur. This is exactly what I meant by it being at the discretion of the user. If you use it, then it populates with values you have previously used. This you can add to with a new value or use again so as to standardise your Occupation description. Alan -Original Message- From: Ron Ferguson [mailto:ronfergy@tiscali.co.uk] Sent: 11 February 2012 12:57 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] OCCUPATIONS LIST Alan, Whilst that may well work for you, it will not work for me because (a) I do not have an IDER value of 47, and (b) the way I use that Events is clearly very different to that used by yourself. In other words, for many (most?) people it will give totally stupid result. I cannot think of anyway of doing this where the method of using a function is at the discretion of the user. Ron Ferguson http://www.fergys.co.uk/ -Original Message- From: Alan Pereira Sent: Saturday, February 11, 2012 11:27 AM To: LegacyUserGroup@LegacyUsers.com Subject: RE: [LegacyUG] OCCUPATIONS LIST 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
RE: [LegacyUG] OCCUPATIONS LIST
Ron, the IDET of 51 is used for Probate Alan -Original Message- From: Ron Ferguson [mailto:ronfergy@tiscali.co.uk] Sent: 11 February 2012 15:00 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] OCCUPATIONS LIST Alan, I do have an Event/Fact Occupation. However its IDET has a value of 51. Ron Ferguson http://www.fergys.co.uk/ -Original Message- From: Alan Pereira Sent: Saturday, February 11, 2012 1:19 PM To: LegacyUserGroup@LegacyUsers.com Subject: RE: [LegacyUG] OCCUPATIONS LIST Ron, you have answered your own comment. If you do not use the event Fact occupation then you will not have an IDET=47. This drop down list will, for you, not occur. This is exactly what I meant by it being at the discretion of the user. If you use it, then it populates with values you have previously used. This you can add to with a new value or use again so as to standardise your Occupation description. Alan -Original Message- From: Ron Ferguson [mailto:ronfergy@tiscali.co.uk] Sent: 11 February 2012 12:57 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] OCCUPATIONS LIST Alan, Whilst that may well work for you, it will not work for me because (a) I do not have an IDER value of 47, and (b) the way I use that Events is clearly very different to that used by yourself. In other words, for many (most?) people it will give totally stupid result. I cannot think of anyway of doing this where the method of using a function is at the discretion of the user. Ron Ferguson http://www.fergys.co.uk/ -Original Message- From: Alan Pereira Sent: Saturday, February 11, 2012 11:27 AM To: LegacyUserGroup@LegacyUsers.com Subject: RE: [LegacyUG] OCCUPATIONS LIST 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
Re: [LegacyUG] OCCUPATIONS LIST
On 2012/02/10 12:37, Alan Pereira wrote: SELECT distinct tblER.Description FROM tblER WHERE (((tblER.IDET)=47)); In my family file, this selects one type of Event/Fact with two entries. The Event was one that I created myself and labelled as Military Service. So as Ron said, you can't generalise this for everyone. -- Regards, Mike Fry Johannesburg 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
Re: [LegacyUG] OCCUPATIONS LIST
Thank you Dennis ;-) Ron Ferguson http://www.fergys.co.uk/ -Original Message- From: Dennis M. Kowallek Sent: Saturday, February 11, 2012 3:52 PM To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] OCCUPATIONS LIST On Sat, 11 Feb 2012 15:44:55 -, Alan Pereira alanpere...@tiscali.co.uk wrote: Ron, the IDET of 51 is used for Probate Alan, the IDETs are not hard coded. Every database could be different. Not that it really matters because one can find the Occupation master event via a join. -- Dennis Kowallek (LTools/Custom Programming) http://zippersoftware.com/ltools/index.htm http://groups.yahoo.com/group/ltools NOTE TO LUG USERS: Use plain text if you want me to read your post. 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
RE: [LegacyUG] OCCUPATIONS LIST
My Apologies to all for not understanding the nature of the IDET code. As Dennis says, a join is required to establish the, so the query to support a drop down list becomes... SELECT DISTINCT tblER.Description FROM tblET INNER JOIN tblER ON tblET.IDET = tblER.IDET WHERE (((tblET.EventType)=Occupation)) ORDER BY tblER.Description Thank you Dennis for correcting my understanding of these tables. Alan -Original Message- From: Ron Ferguson [mailto:ronfergy@tiscali.co.uk] Sent: 11 February 2012 16:07 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] OCCUPATIONS LIST Thank you Dennis ;-) Ron Ferguson http://www.fergys.co.uk/ -Original Message- From: Dennis M. Kowallek Sent: Saturday, February 11, 2012 3:52 PM To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] OCCUPATIONS LIST On Sat, 11 Feb 2012 15:44:55 -, Alan Pereira alanpere...@tiscali.co.uk wrote: Ron, the IDET of 51 is used for Probate Alan, the IDETs are not hard coded. Every database could be different. Not that it really matters because one can find the Occupation master event via a join. -- Dennis Kowallek (LTools/Custom Programming) http://zippersoftware.com/ltools/index.htm http://groups.yahoo.com/group/ltools NOTE TO LUG USERS: Use plain text if you want me to read your post. 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
Re: [LegacyUG] OCCUPATIONS LIST
And the Occupation would have to be changed for each of the Non-English versions of Legacy since the Event names change with the languages. 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 11/02/2012 11:38 AM, Alan Pereira wrote: My Apologies to all for not understanding the nature of the IDET code. As Dennis says, a join is required to establish the, so the query to support a drop down list becomes... SELECT DISTINCT tblER.Description FROM tblET INNER JOIN tblER ON tblET.IDET = tblER.IDET WHERE (((tblET.EventType)=Occupation)) ORDER BY tblER.Description Thank you Dennis for correcting my understanding of these tables. 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
RE: [LegacyUG] OCCUPATIONS LIST
Hi Everyone I was looking to have a master list like 'locations' that would show me all the individuals I had entered who did a specific job compiled from data I had already entered under 'occupation'. There are a number of research advantages to such a list. Just a couple = If like me you have families continually giving children same names but they follow different profession then if you get an apprenticeship record or occupation details in a source it's easier to locate correct person.Helps track families' life-style and migration if they have done work affected by industrialisation and other changes. Useful for looking in sources you might not otherwise consider. I have often found links to how they met future spouses in this way. Carol Date: Thu, 9 Feb 2012 19:26:25 -0800 From: paula.ryb...@sbcglobal.net Subject: Re: [LegacyUG] OCCUPATIONS LIST To: LegacyUserGroup@LegacyUsers.com Jenny, WOW!!!How did you figure out how to do all that?? ;) I think maybe the OP was wanting a drop-down list of occupations to select from when entering... I don't know... a new field for the individual? However, your approach did point out to me the MANY ways I have been entering data for an Occupation event over the years! Oh dear, I see another clean-up task on my horizon! ;)Thanks, --Paula in Texas Researching: Adair Baker Beasley Benson Betz Bigley Blagrave Burton Chapman Clement Clough Coppernoll Costine Daulton Dinwiddie Doody Ellis Exline Field Floran Floyd Gates Goodale Gordon Gump Hale Harbaugh Hind Hopkins Hughes Hurdle Jones Klein Koyle Laswell McDonald Misner Passwaters Pelton Roberts Roche Ryburn Sanford Short Singer Sullivan Weller Williams From: Jenny M Benson ge...@cedarbank.me.uk To: LegacyUserGroup@LegacyUsers.com Sent: Thu, February 9, 2012 10:26:00 AM Subject: Re: [LegacyUG] OCCUPATIONS LIST On 09/02/2012 13:21, cr brassfield wrote: Is there some way I can create an 'Occupations' list. Try this, it works but the result might not be exactly how you'd like it. First, open the Event Definitions Master List, select Occupation and click Show List. Now click the Create Search List button and click Create New List. Click Close, then Close again and a message will appear asking if you want to show the results. Click OK and the list will appear as a Name List. Now click print and select the fields to appear on your Report. You will want at least Surname, Given names so check the box next to that and click the Options button next to Optional Fields. On the next screen, click one of the buttons with 3 dots on next to a field you *don't* want and select Event from the resulting list. Select Occupation from the next list. Click Close and then check the box next to Event: Occupation. Nearly there! No click Preview and see if you are happy with the results. You can make some small alterations to the layout before printing if you want. -- Jenny M Benson 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 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
Re: [LegacyUG] OCCUPATIONS LIST
On 10/02/2012 03:26, Paula Ryburn wrote: How did you figure out how to do all that?? ;) Started by wondering if a specific Event was one of the fields one could select to display in a print-out of the Name List. When I discovered it was, I went back to work out how to get the right Names in the list - was thinking it might involve tagging, but it didn't, of course. I think maybe the OP was wanting a drop-down list of occupations to select from when entering... I don't know... a new field for the individual? I can think of 2 reasons for that being impractical. For one, there are just far too many occupations. Secondly, what would you do about someone who had 2, 3 or more occupations over their lifetime? -- Jenny M Benson 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
RE: [LegacyUG] OCCUPATIONS LIST
There is another way if you know how to use MSACCESS Change the fdb extension to mdb open in MSAccess Create the following query in sql view SELECT distinct tblER.Description FROM tblER WHERE (((tblER.IDET)=47)); Display the results and copy paste into Excel as your master Occupations List Do not save the query close MSAccess Rename back from mdb to fdb Alan Pereira -Original Message- From: Jenny M Benson [mailto:ge...@cedarbank.me.uk] Sent: 09 February 2012 16:26 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] OCCUPATIONS LIST On 09/02/2012 13:21, cr brassfield wrote: Is there some way I can create an 'Occupations' list. Try this, it works but the result might not be exactly how you'd like it. First, open the Event Definitions Master List, select Occupation and click Show List. Now click the Create Search List button and click Create New List. Click Close, then Close again and a message will appear asking if you want to show the results. Click OK and the list will appear as a Name List. Now click print and select the fields to appear on your Report. You will want at least Surname, Given names so check the box next to that and click the Options button next to Optional Fields. On the next screen, click one of the buttons with 3 dots on next to a field you *don't* want and select Event from the resulting list. Select Occupation from the next list. Click Close and then check the box next to Event: Occupation. Nearly there! No click Preview and see if you are happy with the results. You can make some small alterations to the layout before printing if you want. -- Jenny M Benson 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
Re: [LegacyUG] OCCUPATIONS LIST
On 10/02/2012 10:37, Alan Pereira wrote: There is another way if you know how to use MSACCESS Change the fdb extension to mdb open in MSAccess Create the following query in sql view SELECT distinct tblER.Description FROM tblER WHERE (((tblER.IDET)=47)); Display the results and copy paste into Excel as your master Occupations List Do not save the query close MSAccess Rename back from mdb to fdb Except, as I have pointed out before, there is no need to rename your .fdb file. Access is quite happy to open *.fdb files. It saves a couple of steps. -- Jenny M Benson 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
Re: [LegacyUG] OCCUPATIONS LIST
There is no need to change the extension of the file to mdb. I just right-click on the fdb file, select Open with and Microsoft Access . Of course, before doing anything with your database outside of Legacy, make a backup copy! Mary Sent from my iPad On Feb 10, 2012, at 5:37 AM, Alan Pereira alanpere...@tiscali.co.uk wrote: There is another way if you know how to use MSACCESS Change the fdb extension to mdb open in MSAccess Create the following query in sql view SELECT distinct tblER.Description FROM tblER WHERE (((tblER.IDET)=47)); Display the results and copy paste into Excel as your master Occupations List Do not save the query close MSAccess Rename back from mdb to fdb Alan Pereira -Original Message- From: Jenny M Benson [mailto:ge...@cedarbank.me.uk] Sent: 09 February 2012 16:26 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] OCCUPATIONS LIST On 09/02/2012 13:21, cr brassfield wrote: Is there some way I can create an 'Occupations' list. Try this, it works but the result might not be exactly how you'd like it. First, open the Event Definitions Master List, select Occupation and click Show List. Now click the Create Search List button and click Create New List. Click Close, then Close again and a message will appear asking if you want to show the results. Click OK and the list will appear as a Name List. Now click print and select the fields to appear on your Report. You will want at least Surname, Given names so check the box next to that and click the Options button next to Optional Fields. On the next screen, click one of the buttons with 3 dots on next to a field you *don't* want and select Event from the resulting list. Select Occupation from the next list. Click Close and then check the box next to Event: Occupation. Nearly there! No click Preview and see if you are happy with the results. You can make some small alterations to the layout before printing if you want. -- Jenny M Benson 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 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
Re: [LegacyUG] OCCUPATIONS LIST
I agree with you on the impracticality of a master list of occupations. I think nearly all the occupations I have came from US census listings, and it's not like those enumerators had a standard list they used. The reporting method you provided is enough for me, should I need to examine my file for particular occupations. I think the only really standard one I have is farmer ;) --Paula From: Jenny M Benson ge...@cedarbank.me.uk To: LegacyUserGroup@LegacyUsers.com Sent: Fri, February 10, 2012 4:35:03 AM Subject: Re: [LegacyUG] OCCUPATIONS LIST On 10/02/2012 03:26, Paula Ryburn wrote: How did you figure out how to do all that?? ;) Started by wondering if a specific Event was one of the fields one could select to display in a print-out of the Name List. When I discovered it was, I went back to work out how to get the right Names in the list - was thinking it might involve tagging, but it didn't, of course. I think maybe the OP was wanting a drop-down list of occupations to select from when entering... I don't know... a new field for the individual? I can think of 2 reasons for that being impractical. For one, there are just far too many occupations. Secondly, what would you do about someone who had 2, 3 or more occupations over their lifetime? -- Jenny M Benson 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
RE: [LegacyUG] OCCUPATIONS LIST
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 From: Paula Ryburn [mailto:paula.ryb...@sbcglobal.net] Sent: 10 February 2012 16:36 To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] OCCUPATIONS LIST I agree with you on the impracticality of a master list of occupations. I think nearly all the occupations I have came from US census listings, and it's not like those enumerators had a standard list they used. The reporting method you provided is enough for me, should I need to examine my file for particular occupations. I think the only really standard one I have is farmer ;) --Paula _ From: Jenny M Benson ge...@cedarbank.me.uk To: LegacyUserGroup@LegacyUsers.com Sent: Fri, February 10, 2012 4:35:03 AM Subject: Re: [LegacyUG] OCCUPATIONS LIST On 10/02/2012 03:26, Paula Ryburn wrote: How did you figure out how to do all that?? ;) Started by wondering if a specific Event was one of the fields one could select to display in a print-out of the Name List. When I discovered it was, I went back to work out how to get the right Names in the list - was thinking it might involve tagging, but it didn't, of course. I think maybe the OP was wanting a drop-down list of occupations to select from when entering... I don't know... a new field for the individual? I can think of 2 reasons for that being impractical. For one, there are just far too many occupations. Secondly, what would you do about someone who had 2, 3 or more occupations over their lifetime? -- Jenny M Benson 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
Re: [LegacyUG] OCCUPATIONS LIST
There are two ways you can create a report like this: 1. Click on the Reports icon, select the Books/Other tab and then the Event report. You can create a report on one specific event type for any or all persons. 2. Create a Name List or Search List report. Bring up the Name List or your Search List, click on Print and add up to 30 fields of data (in the Deluxe) to the report. You can search for all people who were grocers by clicking on the Search icon, selecting the Detailed Search tab and do the following search: Look for whom? Individuial Where to look Event Description How to look Contains What to look for Grocer Sincerely, Sherry Technical Support Legacy Family Tree On Fri, Feb 10, 2012 at 12:08 AM, cr brassfield crbrassfi...@hotmail.com wrote: Hi Everyone I was looking to have a master list like 'locations' that would show me all the individuals I had entered who did a specific job compiled from data I had already entered under 'occupation'. There are a number of research advantages to such a list. Just a couple = If like me you have families continually giving children same names but they follow different profession then if you get an apprenticeship record or occupation details in a source it's easier to locate correct person. Helps track families' life-style and migration if they have done work affected by industrialisation and other changes. Useful for looking in sources you might not otherwise consider. I have often found links to how they met future spouses in this way. Carol 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
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
RE: [LegacyUG] OCCUPATIONS LIST
Hi Alan, I use the 'title suf', after the person's name to record the person's main occupation in square brackets. For example, mine would be Michael Angus Bridgeford [mech.engineer]. It may not be sortable, but it give me a very quick and ready guide to a person's main occupation, which helps with the identification of other information relevant to him. I do not normally put in the female's occupation, unless it is relevant. Regards, Mike bridgeford -Original Message- From: Brian/Support [mailto:br...@legacyfamilytree.com] Sent: 11 February 2012 07:13 AM 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
Re: [LegacyUG] OCCUPATIONS LIST
On 2012/02/09 15:21, cr brassfield wrote: Is there some way I can create an 'Occupations' list. A couple of years ago I sent it as a suggestion for a master list but nothing has happened. No such table in the database yet. That's what it needs. At the moment, Occupations can only be a fact/event. -- Regards, Mike Fry Johannesburg 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
Re: [LegacyUG] OCCUPATIONS LIST
Jenny, WOW!!! How did you figure out how to do all that?? ;) I think maybe the OP was wanting a drop-down list of occupations to select from when entering... I don't know... a new field for the individual? However, your approach did point out to me the MANY ways I have been entering data for an Occupation event over the years! Oh dear, I see another clean-up task on my horizon! ;) Thanks, --Paula in Texas Researching: Adair Baker Beasley Benson Betz Bigley Blagrave Burton Chapman Clement Clough Coppernoll Costine Daulton Dinwiddie Doody Ellis Exline Field Floran Floyd Gates Goodale Gordon Gump Hale Harbaugh Hind Hopkins Hughes Hurdle Jones Klein Koyle Laswell McDonald Misner Passwaters Pelton Roberts Roche Ryburn Sanford Short Singer Sullivan Weller Williams From: Jenny M Benson ge...@cedarbank.me.uk To: LegacyUserGroup@LegacyUsers.com Sent: Thu, February 9, 2012 10:26:00 AM Subject: Re: [LegacyUG] OCCUPATIONS LIST On 09/02/2012 13:21, cr brassfield wrote: Is there some way I can create an 'Occupations' list. Try this, it works but the result might not be exactly how you'd like it. First, open the Event Definitions Master List, select Occupation and click Show List. Now click the Create Search List button and click Create New List. Click Close, then Close again and a message will appear asking if you want to show the results. Click OK and the list will appear as a Name List. Now click print and select the fields to appear on your Report. You will want at least Surname, Given names so check the box next to that and click the Options button next to Optional Fields. On the next screen, click one of the buttons with 3 dots on next to a field you *don't* want and select Event from the resulting list. Select Occupation from the next list. Click Close and then check the box next to Event: Occupation. Nearly there! No click Preview and see if you are happy with the results. You can make some small alterations to the layout before printing if you want. -- Jenny M Benson 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