Wing Fong

Very good ! it works. Thanks a bunch. -wing

I have a layout with the following parts in it: Title sub summary sub summary body footer When I view it in browse mode everything appears as I expect, when I switch to previw, everything appears as I expect again. Then, If I perform a find, the browse is correct, but when I switch to preview mode, everything in the two sub summary parts does not show up. If I switch back to browse they are there. If I show all the records and then go back to preview the sub summarys don't show up again. I've checked to make sure all the elements in the two parts are set to print, and can't think of anything else to check out. Any suggestions are greatly appreciated. Thanks!! -wing

ahh...I see. I can write that into my script. Thanks! -w

Hi, I've changed this post a bit. How can you do the above, but instead of it searching for "cat" AND "tree", make it search for "cat" OR "tree"? I'm trying to write a script that will search for one of two words in a field and return all records with one or other of those words. Thanks! -wing

Hi all, thanks for the help. I figured it out. I selected every item / field in the layout and told them all to slide up. It seems to work now. Not sure why, but it does. (yes, I had reduce size of enclosing part selected) thanks again. -wing

I don't believe it is. The "part definition" has no options checked. Is there another location that that option would be located? It doesn't show up under "part definition". Do you think the sliding option is the culprit perhpas? thanks! -wing

hi, I'm putting together a layout that has these five parts 1. header 2. sub summary - sorted by field A 3. sub summary - sorted by field b 4. body 5. footer It worked great and then I had to go change it. The problem is that the second sub summary (number 3 sorted by field will always start on another page. It will not start directly underneath the first sub summary. There's plenty of room, and it doesn't have the "start on next page option" selected. I had a similar report previously that worked fine, only difference was the fields are now set to slide up. Any suggestions would be great. Thanks! (if it helps I'm on a Mac running os 9, with FM pro 5.5) -wing

Yes, I guess that was two questions. I couldn't get your script to work, but I used the theory and just made two fields for each. I then had a problem, I think, because I was using numbers like "01" and the zero in front was causing problems, and or my field definitions should have been "number" not "text". But, I worked it out. Thanks for the help! -wing

Great, I'm gonna give it a shot. One question: Do I need to define that global field first? And if so, do I also need to physically put it on all the layouts? Thanks! -wing

Hello, I have two fields (A and :. They contain two digits each. I'm trying to create a script that will perform a find for any other entries that share the same values in A and B, of the entry, that the button is attached to. For example. One entry has field A equaling 01 and field B equaling 02. I'd like the script to see and remember both values from field A and B, enter the find mode, and assign these values to the appropriate fields. I was hoping that I could set up some sort of variable to temporarly store these values, whetever they may be. The reason why is so I could only write one scrip for this instead of specific scripts depending on what button it's attached to. I first used a copy and paste command, but that only allows the script to remember one number. Thanks for any suggestions. -wing