I am new to Filemaker and have inherited a single table db which is published via the web companion and uses a single search page built using HomePage 3.0. The database holds information on accommodation for students such as location, size, smoker - non-smoker preferred etc.

The problem I have is that users can only do OR searches in the form therefore if they choose a room for a non-smoker in a particular area it pulls back all non-smoker rooms and also all rooms in said area. I need to do an AND search but changing the -LOP value in the search page to AND results in no records being found. The search page uses dropdowns and checkboxes built on value-lists and so I am not sure how to base a search on a concatenated field made up of the necessary fields.

Instant web publishing seems to allow for AND searches so why not other HTML search pages?

Can anyone help?

Without seeing the whole Form it may be a bit hard to see why the AND search is not working.

All the best.

Garry

Hi Garry,

Form can be found online here http://www.accom.gla.ac.uk/pad/FMPro?-db...h.htm&-view

Please feel free to have a look.

Thanks,

Brian

I found this at the start of the Form:

<INPUT TYPE="hidden" NAME="-SortORder" VALUE="Ascending"><INPUT TYPE="hidden" NAME="-op" VALUE=cn><INPUT TYPE="hidden" NAME="-op" VALUE=cn><INPUT TYPE="hidden" NAME="-op" VALUE=cn><INPUT TYPE="hidden" NAME="-op" VALUE=cn><INPUT TYPE="hidden" NAME="-op" VALUE=cn><INPUT TYPE="hidden" NAME="-op" VALUE=cn><INPUT TYPE="hidden" NAME="-op" VALUE=cn><div align="center"><INPUT TYPE="hidden" NAME="-Max" VALUE="2500">

You may want to place just one of these immediately before the "AccommodationFor" field.

I also found this in there:

<INPUT TYPE="hidden" NAME="-LOP" VALUE=OR>

Hence, the "AND" search will not work.

Good Luck.

Garry