Hi I have a table called tblBooking with following fields
performance (data type number) primary key
Seatnumber (data type text) primary key
status (data type text) primary key
Ticketprinted (data type yes/no)
status at the start is all filled in with "FREE" when a customer makes a booking the customer primary key is entered so thus "FREE" becomes ALA025.
I have created a querry called qryTicketDetails using fields from tblCustomer, tblPerformance and tblSeat.
In qryTicketDetails I want check for customers that has made a booking what is the best way to do this?