Have 4 global fields; hotel, roomType, startDate, endDate. The hotel and room type generate a unique key for that combination (roomAssignID). What I am trying to do is to enter values in those fields and display a list of all matching rooms in a portal below. The relationship is from the search table (where the globals are) to a tblAllocations which has a record for every combination of roomAssignID and date.
In the relationship, there are three criteria:
roomAssignID = roomAssignID
startDate >= date
endDate < date
Not only is this not giving me matching records but the moment I select a value in the Hotel field, the portal populates with all matching records for that hotel; I thought this was because the previous value in the hotel field was not being cleared even though it appeared to be but that doesn't make much sense either.
TIA.