O
Olly Bowman
I am trying to create a booking system for a ski school.
I have a form called "frm-dates" which is based on a table called
"tbl-dates". Each record has a field for the date, and then a field for each
ski instructor.
In each of these instructor fields a number is stored, either an integer to
represent if the instructor is booked which relates to a booking reference,
or a 0 to represent if the instructor is free.
In frm-dates, when I click on a control for an instructor field another form
opens that stores the booking records based on a table called "tbl-booking"
this form is called "frm-booking". If the field has a value not equal to 0
then the appropriate booking opens in frm-booking. All this works fine.
If the field has a value of 0 how do i take the date from frm-dates and the
name of the field and put them in the date field and instructor field
respectively in a new record in frm-booking?
Hope someone can help.
Olly Bowman.
I have a form called "frm-dates" which is based on a table called
"tbl-dates". Each record has a field for the date, and then a field for each
ski instructor.
In each of these instructor fields a number is stored, either an integer to
represent if the instructor is booked which relates to a booking reference,
or a 0 to represent if the instructor is free.
In frm-dates, when I click on a control for an instructor field another form
opens that stores the booking records based on a table called "tbl-booking"
this form is called "frm-booking". If the field has a value not equal to 0
then the appropriate booking opens in frm-booking. All this works fine.
If the field has a value of 0 how do i take the date from frm-dates and the
name of the field and put them in the date field and instructor field
respectively in a new record in frm-booking?
Hope someone can help.
Olly Bowman.