search for multiple enries in a single field

[jebarber]

Ok, First off I am very new to using Filemaker (or any database for that matter) so this may be a dumb question.

Here is what I am trying to do:

I have a database, In that database there is a field called "location"

It contains room numbers. On a different web server I have a page that has a map on it with numbered rooms, I have it set up so that if you click on a room it gives you the results page fom the database as if you had done a search on the database for that room number. That is all working perfectly.

I have a few places where I would like it to return the result from two different locations, as in I want to see who is in room 102 and 103.

Or maybe I want to see who is in all the rooms on the 1st floor.

Is there a way to make a hyperlink that return the results for two or more entries from the same field?

[Garry Claridge]

Your find can use parameters like this:

&room_mun=102 103&-find

or

<input type="text" name="room_num" value="102 103">

This will usually be inconjuction with "-lop=or".

Check the "CDML Reference" database (from the FM site) for "Logical Operator".

All the best.

Garry

[Keith M. Davie]

There was a recent discussion on this subject which you might find useful as well.

http://www.fmforums.com/threads/showthreaded.php?Cat=&Board=UBB22&Number=38394&Search=true&Forum=All_Forums&Words=&Match=Entire%20Phrase&Searchpage=1&Limit=25&Old=1day&Main=38314

[jebarber]

Thanks,

I'll try it on monday when I get to work.

I tried everything between the two values, never accured to me to try a space. lol