Hotel database availability query in sql?

i have an access database with a table called rooms and it contains a field called availability from the type check box and i have another table called check in that is linked to a form and the room number field comes from a combo box which get its value from a query that choses only the room numbers that has the availability field marked as true and what my problem is that i can't find a way to make database mark the room availability as false when i check in some one with the form and also mark it as true when i check the guest out taking into consideration that the check out procedure is a query that inserts the row chosen using the room number into another table called history and deletes it from the table check in
please help me with an sql code or a vb code
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!