I have somewhat of a complex search page that is pretty limited on flexibility [clients request this format...]. The find page is setup so that the user may select a ''description type'' [checkbox format], ''employee size'', ''state'' and etc. However, they requested [color:red]3 pull down menus selecting''city'' [color:black][color:red][3 different cities] and the same for county, and zip code.

Global variables didn't work because you couldn't search in find mode, which was problematic.

I've been having weeks of trouble scripting this. My ultimate solution was to have a button labeled ''add more'' under the fields that needed more requests. This button has the code:

• Duplicate request/record
  
• clear field [city for city field, county for county field, etc.]
  

At first I thought this worked but now there is one problem:

If a user tries to select more than one checkbox the find results only return these parameters under one city, county or zip. I don't understand what's the cause.

It would be greatly appreciated if someone could help me out. Attached is a dummy-type file of my program. login: test password:test

Please note I'm a novice. Also note that the user will be viewing this in ''guest'' mode and will not have any access to changing the database...you can try it out in guest mode if desired.

Thanks.

upload.zip

The trouble is in the "finding_finalscript Copy" script, which processes the multiple checkbox selections, putting each into a new request. It is only doing this with the last City.

But I think because of the variety of possibly requests, I'd go with a filtered relationship to show search results instead. This involves using globals for the search criteria, and a multi-criteria relationship to show the results. In the attached example, I show the results in a portal, but you could then use a Go to Related Records[] script step to jump to those matching records and show them in a list, or print your labels. I only included a few of your search fields in the example, but you can add additional criteria in the same manner.

upload.fp7.zip

I appreciate your help. I'm starting to get on the right track...however when I used your ''go to related records'' script suggestion [ using a button ] it only shows one record in the different layout. How can I make it show all of the related records?

Just let me know. Thank you so much.

Check the relationship for the Go to Related Records[] script step. In my example, it would use the "Contact Management" relationship.

It's working...wow I greatly appreciate your help.

Is there an easy way to to create a field or space on the next layout where the user can see what search parameters they chose?

Just let me know.

! Thanks again.

Thanks, I finally got it!

I appreciate all your time...