Thank you Gentlemen, It is a new world indeed! I'm actually going from child to parent ... so there are many records with the multiple same ID and I want only the people that bought them. So from these purchased concerts give me names of the people that ought, so from ticket sales back to contacts ... still gonna work??
Loretta On 13/02/2008, Jason L DeLooze <[EMAIL PROTECTED]> wrote: > Hi Loretta - and welcome to a new world! > > Expanding on Tim's advice: In FMP 6, the "Go To Related Records" (GTRR) > command worked only on the current Parent record, allowing us to jump from a > single Parent record to that Parent's related Child records. In FMP 7 (and > later), the GTRR command has an additional option - "Match All records in > Current Found Set" - which allows us to jump from the Current Found Set of > Parent records to _all_ their related Child records. To accomplish this same > task in FMP 6, we had to do as you described: grab all ParentID values via > Copy All Records, paste that List of ParentIDs into a global field (making it > a multi-key), then performing a GTRR from this (multi-key) global text field > to the related Child records. > > There is a behavior difference you must know: in FMP 6, if there are __no__ > related records, a GTRR would produce an empty Found Set of related Child > records; in FMP 7+, if there are __no__ related records, a GTRR will _not_ > change the existing Found Set to an empty set, but will leave the original > Found Set as it was before the GTRR. Therefore, you must check that Related > Records actually exist )before_ the GTRR; otherwise, you may be working on > the wrong related record set. > > Best wishes, > > Jason L. DeLooze > Annapolis, MD USA > > > > > On 2/13/08 at 4:49 PM -0800, Loretta James wrote: > >I am new to FMP 9, last version I used was 6 so the new format is > >unfamiliar. My question is, I used to move to a related group of > >people from the tickets they purchased by doing a Copy All from the ID > >field on the tickets purchase screen, pasting in a text global on > >tickets purchased screen. Using a relationship to Contacts ID, Go to > >Related Show only related in Contacts. Not working I'm sure it's > >simple but I'm not seeing it ... anyone's help very much appreciated. > > > >Thank you, > >L J >
