Multiple Match problem

[dave2000]

Hi everyone,

I work for a real estate company and am trying to get a buyer matching system working. I have all the property records in one database and them i am working on a new 'prospects' Database. I am trying to display the matching properties records in a portal in the prospects database

I have 2 match fields... property_type and property_area that i want to be able to search by

I have a calculation field to concatenate the fields then i use that as a relationship. Then a similar calc field in the property database so the fields match up. (i got that part working from another post here..'using multiple match fields, is this possible?')

Well it works ok if i fill in 2 of the match fields but my question is

how do i get it to work if i just want to fill in one, Ideally if both these fields are blank it should display all the records. Then if i select 'house' as a property type it should display all the houses regardless of the area and vice versa.

I have tried everything! hope somebody can help me... thankyou!

Dave

[comment]

Try something like this:

On left side, i.e. in prospects:

Case (

isEmpty ( property_type ) and isEmpty ( property_area ) , "ALL" ;

property_type &

Case ( not ( isEmpty ( property_type ) or isEmpty ( property_area ) ) ; " " ) &

property_area

)

On right side, i.e. in properties:

property_type & " " & property_area & "

[dave2000]

Hey thanks comment,

just to help me understand a bit better what is the purpose of the

"

[comment]

There are 4 possible situations in prospects (both fields empty, one of the two fields empty, and both fields filled). There are 4 lines in the property field key. Any single line will match one of the 4 possible situations.