Show Properties based on Customer Preferences
I have a properties table which has number of bedrooms, price, country etc I have a customers table with preferred Bedrooms, Price and Country etc. How do I match up the properties that fit ALL cr...
Forum Discussion
I don't think that it can be done with an embedded report. It will take a button push at least, although e results after the button push could be on the customer preferences record.
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 ???