B
Brian C
Hi. I'm a novice user trying to do my first project, a
simple room booking system.
I have a form called SINGLE BOOKING AVAILABILITY with
three input field called Date, Combo8 and Combo10 and a
command button.
I have a form in which users enter three values, date,
period and room. I want to then run a query against an
AVAILABILITY table that is keyed on these three fields to
return another field from the same table called booking
number.
If this booking number field contains a 1 then I want to
move to another form where the user will enter details
which will then be used to update a BOOKING table. The
BOOKING table is keyed on Booking number which is an
AUTONUMBER. I then want to update the booking number field
in the original AVAILABILITY record with this number.
What does the SQL look like to do this?
Where do I put the SQL? I assume the first part goes
somewhere on the first form, the second part on the second
form but what happens to the last part where I want to
update the original record?
Finally is there a way of getting the AVAILABILITY record
for update and holding on to it until I have completed
creating the BOOKING record and then updaing and releasing
it? If so but it doesn't contain 1 then how do I release
it without update?
Thanks in advance for your help
simple room booking system.
I have a form called SINGLE BOOKING AVAILABILITY with
three input field called Date, Combo8 and Combo10 and a
command button.
I have a form in which users enter three values, date,
period and room. I want to then run a query against an
AVAILABILITY table that is keyed on these three fields to
return another field from the same table called booking
number.
If this booking number field contains a 1 then I want to
move to another form where the user will enter details
which will then be used to update a BOOKING table. The
BOOKING table is keyed on Booking number which is an
AUTONUMBER. I then want to update the booking number field
in the original AVAILABILITY record with this number.
What does the SQL look like to do this?
Where do I put the SQL? I assume the first part goes
somewhere on the first form, the second part on the second
form but what happens to the last part where I want to
update the original record?
Finally is there a way of getting the AVAILABILITY record
for update and holding on to it until I have completed
creating the BOOKING record and then updaing and releasing
it? If so but it doesn't contain 1 then how do I release
it without update?
Thanks in advance for your help