my head bursts because of a probably very simple problem:
I have two tables: Booking and a lookup table Rooms.
I want the Booking table to show only those rooms in the selection that are not already included (i.e. booked) in the Booking table on a specific day at a specific hour.
I have already managed to display all rooms that are booked on that day at that hour. How can I now limit the selection in the lookup table accordingly?
My code for filtering (date and hour) looks as this:
Booking.Filter([Flur-Date]=thisRow.[Flur-Date] and Contains(TimeRange,thisRow.TimeRange) and rowID!=thisRow.rowID).Room
All rooms that have already been booked are displayed. How can I now display the remaining rooms, i.e. those rooms that are not in the filtered list and therefore still available?
I am very grateful for any help!
With best regards