Hi

I am creating a restaurant table booking system for customers. I have a tables table and a bookings table.

Tables tbl: Table number, Table Status
Bookings tbl: Surname, Booking ID, Table Number (a lookup box with table number and status)


I want this to make it so if i select a table with the status as "In use" it does not let me choose this table, could maybe do this with a simple query lookup box.
I Then want it to change the status on the tables tbl if i select a table which is free by updating the status to In Use.

How can i do this.

Thanks
http://www.access-programmers.co.uk/forums/images/buttons/quote.gif (http://www.access-programmers.co.uk/forums/newreply.php?do=newreply&p=718978)

Hiya you might need to add a start and finish time as restaurants normally like to have multiple people using the same table.

Secondly the best way to work out availability is to have a query of which tables are booked and then query this against all the tables to work out available ones, then intergrate this query into a combo box maybe.

Hi how can I integrate the queries?

1st query is all the tables which are booked for that day or time etc

now I need to query this with all the tables available and show the ones which are not booked? How can I do this second part?


Many Thanks for your help

Ok dont worry I managed to do that using the criteria IS NULL and using the original tables table, and the query of current bookings.

Now:

My query has a parameter where the user can type in a date and time. This is put as a combo box, so when they click the box the paramter runs and they type in the date and time they want the booking for. How can I make it put the date and time already typed in that record into the parameter for me? Is that possible?

Or make it out whatever I type into the parameter appear into a field on the form.

Thanks