Hi ,

I have tired to get this working for a while and have also tried various methods but I just can get it to work.  Max has offered a solution involving a report but I would like to try to get it working like this.  I would like a view in a room booking application that would show me the Rooms/units that have same day arrival and departure, so that I can put some sort of priority on the units that will arrive and depart on the same day. 

This is the solution I am working on:

for each Record in Units[(DepartureDate == input.ArrivalDate && Unit_Number == input.Unit_Number)]

{

            input.QuickTurn=true;

}

I need the script to iterate through all the existing records and  Check the QuickTurn Checkbox to true if the new record has an Arrival Date matching the DepartureDate of an already existing record.  At this point the script that I am using only checks the QuickTurn checkbox on the New record(new entry). 

I hope that I was able to give ample explanation..