Applal

Oops, sorry for the dupe! [ June 12, 2001: Message edited by: Applal ]

Hi Stephie, Try this. It worked for me in a quick trial on one of my databases. Enter Find Mode[pause] (Note, no restore) New Record Request Pause/Resume Script[] Perform Find [] (Note, no restore) The pause resume request gives you a chance to enter your second choice. I don't see any benefit to "going" to a specific field, as in paused find, any data can be entered into any field. If, on the other hand, you wish to isolate finds to just the month field, create a layout called month, and use only that field in it. Then at the beginning of your find request, tell FM to Go To Layout [month] and after "perform find" use Go to Layout [whatever it's called] Hope this helps!

Thanks Bob,for the information, I was trying to do your second example, but setting it up like your first example. I had a little trouble with your example using an "and", but I found that I just had to place two "set field"s within one request. It worked, and I definitely learned something! Thank you very much!

I mean a field formatted as a radio button. I can script a find on the radio buttons value. Works every time. I can script a find on a text field, even with several "new find/requests", and it works every time. I can script a find on the radio button, and a single find request on a text field and it works every time. But as soon as I add the second find on the text field I start getting inconsistant and erroneous find results. ???

I experience the same problem with my database using WC. I don't see an answser in Anatoli's reply unless one were building custom pages to the WC. Does anyone have an answer for this or is it just one of FMP5s/WC shortcomings?

Hello everyone, I have been puzzling over this one for several weeks now, and haven't come up with a combination of script events that will make this work. What I am trying to do is find records in a database based on 2 possible entries into the same text field and a pushbutton toggled on.(out of many pushbuttons). I have no trouble at all setting up a multiple find on the same text field using new record/request, but as soon as I try to do the 3rd step of the find on the pushbutton, results become unpredictable. Either I will get results with records that did not have the pushbutton toggled, or I will get results with records that do not match the 2 possible entries in the same text field. If I just do a find on the pushbutton, my resulting found set is exactly as it should be. If I just do the find on the text field, again, my results are as they should be. I have tried placing the pushbutton find as the first find step, and as the last find step. I have tried setting it up as a called sub-script. Any ideas as to why this behavior?

Thank you for your information. Very helpful. I'll be looking into your suggestions very soon.

Omigosh! Thank you SO much! I tried it on my file and it works perfectly!

I am trying to create a script that will do a FIND on a text field that will result in finding two different words, in this case, City names. I would like to find and show all records with city x AND city y from the same database. I know how to do this with menu commands, but can't seem to find the right combination of script steps to accomplish this. I either get an error, no records found or end up with only the results from the second search city. I have read through the Filemaker Help files and found nothing covering this kind of script. FMP5, if that makes a difference. (I am VERY new to Filemaker, please forgive if I missed something very basic)

Sorry for the long post, but, Here's my project: We have a Filemaker Pro (5) database.

Thank you for your reply! How do I view what instant web publishing is providing then? My eventual goal for this project is to serve a large database of information, that will be in continual growth and change. I wish to have visitors to the site able to view by select categories or perform searches. The database needs to be able to link to addtional information by clicking on a button within a field ( to deliver expanded information about a particular field). Just creating the database has been a daunting task. Now I am unsure how the delivery end should proceed. Do I create a web site that somehow links to my database on my home computer (I have a DSL connection so I think that *may* be possible)? I don't think that just exporting my categories as html and then working them into pages is the way to go, as I can't see how to maintain embedded links when I make a change to the database. Where do I start? Alan

I would like to publish a database on the Web. I have many questions about details of this, but for now, I have created a test database, and want to try out the Web Companion to see how it works. I enable the Web companion checkbox, and go through the sharing setup according to everything I have read, and when I go to my Web Folder, inside my Filemaker folder, there is only the read me file in there. What needs to be done or what am I doing wrong?