Show Properties based on Customer Preferences

I was trying to do with a filtered report but I couldn't work out how to get it to search through all the properties.   It seems like it should be something simple but its not?

I created a relationship between customers and properties and passed up the customer preferred fields up to properties.  Then I created a report in properties with Ask User to select the customer and then another filter to show properties where bedrooms >= to preferred bedrooms.   Still doesnt work ???

There is not a way to simply make a relationship between Customers and properties as you have no natural connection that a property belongs to a single customer.

The lowest Tech solution is to create an <ask the user> report which is waiting for the answer to the number of bedrooms  >= <ask the user> and the price is <= <ask the user>.

Then create a URL formula button (probably check the box to open in a new window) on the customer preference record like this.

URLRoot() & "db/" & [_DBID_my properties _Table] & "?a=q&qid=xx&nv=2&v0=" & totext([# of bedrooms]) & "&v1=" & totext([Price])

So in English that says run the ask the user report qid of xx and  and there are going to be 2 variables - ie questions  (nv=2) and the answer to the first variable v0 is the # of bedrooms and the answer to the 2nd question v1 is the price.

So the button will run the report and answer its own questions and display the result.

Ill have a go at that, thanks

Why would I need an ask the user for bedrooms and price?
The customer table contains fields called Preferred Min Bedrooms and Preferred Max Price.

If my report has these already then should it not just pick them up from the customers table and compare them against the corresponding fields in the Property Table?

The way that the report "picks them up" is by running the report. To run the report you need to push the button.  There is not a way to have a Report Link "report" pick up the values from the customer record without pushing a button.  i have another solution which would display the results on the Customer record, but you would still need to push a button.

If we can bypass the ask the user, I have no aversion to pressing a button to get the report.

That is why i gave you the code to make a button which will run the report, answer it's own question automatically,  and display the result.  The user does not see the <ask the user> question being asked or answered.

What I don't understand is, How can it compare the properties: # of Bedrooms with the Customers: Preferred Bedrooms, with that code.   I'm kindof missing it?

Mick,
Did you try the making the report and the button?  I'm not understanding what you are asking here.  My solution is low tech and native.  There may be fancier solutions which require developer assistance, but what i have offered first is just a down and dirty click a native button and get the query results.  The button takes the Customers preferences and supplies them into a report as a filter and runs the report.