 | |
#1
 
| |||
| |||
|
Just this Record -
10-04-2005
, 05:38 PM
#2
| |||
| |||
|
|
I've historically been using this sequence to convert the 'current' record to the only record in the found set. show all records omit record show omitted is there a simpler way of doign this in FM8... I was wondering what others do. Defining a self-join on the pkey, and goto related records, related records only also works... but I prefer the aboves method because it doesn't require a whole additional TO in the already over cluttered relationship graph... it also works regardless of the context, so i don't need different scripts for different tables. I can't help feeling that there's got to be a better way though... -Dave |
all, omit, show omitted. Script it and put an "Isolate" button on the
layout.
You could also do a scripted find of that record. More steps for the same
result.
Setting up a relationship and using GTRR seems like overkill, especially
if your graph is already cluttered.
Matt
#3
| |||
| |||
|
|
42 wrote on (10/4/2005): I've historically been using this sequence to convert the 'current' record to the only record in the found set. show all records omit record show omitted is there a simpler way of doign this in FM8... I was wondering what others do. Defining a self-join on the pkey, and goto related records, related records only also works... but I prefer the aboves method because it doesn't require a whole additional TO in the already over cluttered relationship graph... it also works regardless of the context, so i don't need different scripts for different tables. I can't help feeling that there's got to be a better way though... I would have to say the simplest way to do it is as you've described: show all, omit, show omitted. Script it and put an "Isolate" button on the layout. You could also do a scripted find of that record. More steps for the same result. Setting up a relationship and using GTRR seems like overkill, especially if your graph is already cluttered. |
well. Another saying springs to mind too: "KISS - Keep It Simple
Stupid", why complicate something that's working fine as it is.
)Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
#4
| |||
| |||
|
|
In article <GxF0f.925$OL5.764@trndny05>, "Matt Wills" <I'm (AT) Witz (DOT) end wrote: 42 wrote on (10/4/2005): I've historically been using this sequence to convert the 'current' record to the only record in the found set. show all records omit record show omitted is there a simpler way of doign this in FM8... I was wondering what others do. Defining a self-join on the pkey, and goto related records, related records only also works... but I prefer the aboves method because it doesn't require a whole additional TO in the already over cluttered relationship graph... it also works regardless of the context, so i don't need different scripts for different tables. I can't help feeling that there's got to be a better way though... I would have to say the simplest way to do it is as you've described: show all, omit, show omitted. Script it and put an "Isolate" button on the layout. You could also do a scripted find of that record. More steps for the same result. Setting up a relationship and using GTRR seems like overkill, especially if your graph is already cluttered. Seems like a good case of "if it ain't broke, don't fix it" to me as well. Another saying springs to mind too: "KISS - Keep It Simple Stupid", why complicate something that's working fine as it is. ) |
yeah but i've done that since fm3 -- but FM8 is out now... and with all
the new script steps there wasn't an obvious 'isolate record' step...
but its possible there was a way of doing it within a single script step
now that I hadn't picked up on
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.