good Evening people,
Would anybody be kind enough to assist me with this (to my mind) complex script.
I have a Booking form containing the fields � arrival date (date field) & no of nights booked (numeric field) and eight check-boxes, one for each of up to eight cottages that could theorecally be included in a single booking .
Each booking receives an incremental booking reference (character format)
I then have what is essentially a booking calendar -- a 365 record browse each record being part pre-filled with each date (field1) and each weekday (field2) of the year. Fields 3 � 8 are the bookable cottages.
At present I copy the booking ref. Go to the calendar, find the correct date, move across the fields to the relevant cottage(s) and then paste the booking number into the number of records dictated by the �no of nights� field.
I know, with time I can use the arrival date to point to the correct calendar date, use the cottages checkboxes to point to the correct field(s), and use the number of night to step through and auto-fill in the correct number of records.
Given my present age, I cannot be sure I will live long enough to crack this one.
Just a clue or two will be most welcome, more might find you a niche in my last will and . . .
Thanks
Brianp
Would anybody be kind enough to assist me with this (to my mind) complex script.
I have a Booking form containing the fields � arrival date (date field) & no of nights booked (numeric field) and eight check-boxes, one for each of up to eight cottages that could theorecally be included in a single booking .
Each booking receives an incremental booking reference (character format)
I then have what is essentially a booking calendar -- a 365 record browse each record being part pre-filled with each date (field1) and each weekday (field2) of the year. Fields 3 � 8 are the bookable cottages.
At present I copy the booking ref. Go to the calendar, find the correct date, move across the fields to the relevant cottage(s) and then paste the booking number into the number of records dictated by the �no of nights� field.
I know, with time I can use the arrival date to point to the correct calendar date, use the cottages checkboxes to point to the correct field(s), and use the number of night to step through and auto-fill in the correct number of records.
Given my present age, I cannot be sure I will live long enough to crack this one.
Just a clue or two will be most welcome, more might find you a niche in my last will and . . .
Thanks
Brianp
Comment