RE: [LegacyUG] OCCUPATIONS LIST

2012-02-11 Thread Alan Pereira
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

RE: [LegacyUG] OCCUPATIONS LIST

2012-02-11 Thread Alan Pereira
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

Re: [LegacyUG] OCCUPATIONS LIST

2012-02-11 Thread Ron Ferguson
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

RE: [LegacyUG] OCCUPATIONS LIST

2012-02-11 Thread Alan Pereira
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

Re: [LegacyUG] OCCUPATIONS LIST

2012-02-11 Thread Ron Ferguson
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

RE: [LegacyUG] OCCUPATIONS LIST

2012-02-11 Thread Alan Pereira
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

Re: [LegacyUG] OCCUPATIONS LIST

2012-02-11 Thread Mike Fry
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

Re: [LegacyUG] OCCUPATIONS LIST

2012-02-11 Thread Ron Ferguson
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

RE: [LegacyUG] OCCUPATIONS LIST

2012-02-11 Thread Alan Pereira
)=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

Re: [LegacyUG] OCCUPATIONS LIST

2012-02-11 Thread Brian/Support
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

RE: [LegacyUG] OCCUPATIONS LIST

2012-02-10 Thread cr brassfield
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

Re: [LegacyUG] OCCUPATIONS LIST

2012-02-10 Thread Jenny M Benson
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

RE: [LegacyUG] OCCUPATIONS LIST

2012-02-10 Thread Alan Pereira
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

Re: [LegacyUG] OCCUPATIONS LIST

2012-02-10 Thread Jenny M Benson
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

Re: [LegacyUG] OCCUPATIONS LIST

2012-02-10 Thread M. Brenzel
] 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

Re: [LegacyUG] OCCUPATIONS LIST

2012-02-10 Thread Paula Ryburn
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

RE: [LegacyUG] OCCUPATIONS LIST

2012-02-10 Thread Alan Pereira
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

Re: [LegacyUG] OCCUPATIONS LIST

2012-02-10 Thread Sherry/Support
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

Re: [LegacyUG] OCCUPATIONS LIST

2012-02-10 Thread Brian/Support
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

RE: [LegacyUG] OCCUPATIONS LIST

2012-02-10 Thread Mike Bridgeford
@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

Re: [LegacyUG] OCCUPATIONS LIST

2012-02-09 Thread Mike Fry
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

Re: [LegacyUG] OCCUPATIONS LIST

2012-02-09 Thread Paula Ryburn
: 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