Removing records from relationship

[Kevin Cheesman]

I have a bookings table that has active and cancelled booking. Cancelled booking are shown by a date in a 'booking cancelled' field.

I'm using a relationship to join a table of incremental dates to give me a display of booked a free date, which works well but I can't seem to hide the cancelled bookings. I need to keep them in the table in case of any query.

What's the best way to remove these records?

TIA

[comment]

You could define a calculation field =

Case ( not BookingCancelled ; BookingDate )

and use it in the relationship instead of BookingDate.

[Kevin Cheesman]

Nice one! Thanks for that.