Pertinent Table Info (Pertinent Fields):
Property (prID, prName)
Events (evID, evStatus, evBeginDate, evEndDate, prID, prName)
Properties can be rented by the week . For every week in a given season a property has an event with a start date and end date and a status. Status can be avail or unavail.
Users want to do a search for a date range, say June 1 - June 30, and get a list of properties that are available. With a traditional search, each property can potentially show up 4 times. I want to give them just a list of properties that meet the search with no duplication, but I want the list to be in Browse mode, so I can provide a list of clickable buttons to go with each property, i.e. go to just this property and look at the month of June.
What I've tried:
I've written a report that just shows the single list of properties. Because it's a report I only get the single list if I display in Preview Mode but can't add any clickable buttons, if I display in Browse mode, I'm back to a bunch of records.
I'm very familiar with scripting and am happy to create a script that dumps the necessary info into a temporary table but I cant seem to get to the point that each property appears only once.
Any help is appreciated.