Solved: need to query for booking?

[msa969]

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?

[Imdabaum]

RECAP:
status fields are all FREE until the ticket is booked, then status holds the primary key associated with a customer?

I would think the simplest way to do it would be to query against tblBooking and tblCustomer Joined on Status=customerid if status holds the customer primary key.

[msa969]

Imdabaum,

Your recap is spot on.

I will give your suggestion a go.