Are you trying to find all the Bookings, or the bookings for one member?
I am not sure from your description how you are trying to display the data or how the data is structured.
Normally you would display the members as single form records and the bookings of that member as a subform.
Can you show a printscreen of your Relationships?
Or provide an explanation of what it is your database is designed to do?