Would appreciate some help with the following problem.
I have a booking form into which one enters the arrival date, departure date, and the cottage(s) allocated. The booking reference is an auto-increment field for each booking. There is a further field that calculates the number of actual nights between arrival and departure.
The second table is basically a calendar, with field for each of the cottages.
I am working along the lines of the following
Set up global variables for the arrival date, number of nights and whichever cottage check boxes are logically true.
Enter booking parameters, then �onsave� activate/show the calendar table,
Fetch the calender records till the arrival date is reached. (while not date. Fetch).
Set up a for � to loop for the nights, and a nested loop to check each record for the cottages that equate to true, entering the booking reference number in each record for each cottage for each night,
I have set up the first record manually in case my explanation is wanting.
I wonder if the solution could be better achieved using �case�, �Wend�, �if then� or some form of Posting.
Attached a �.exe cut-down booking form and calendar �browse form�
I somehow think that this problem and solution must be of interest to a whole bunch of people learning to use Alpha V.
Brianp.
I have a booking form into which one enters the arrival date, departure date, and the cottage(s) allocated. The booking reference is an auto-increment field for each booking. There is a further field that calculates the number of actual nights between arrival and departure.
The second table is basically a calendar, with field for each of the cottages.
I am working along the lines of the following
Set up global variables for the arrival date, number of nights and whichever cottage check boxes are logically true.
Enter booking parameters, then �onsave� activate/show the calendar table,
Fetch the calender records till the arrival date is reached. (while not date. Fetch).
Set up a for � to loop for the nights, and a nested loop to check each record for the cottages that equate to true, entering the booking reference number in each record for each cottage for each night,
I have set up the first record manually in case my explanation is wanting.
I wonder if the solution could be better achieved using �case�, �Wend�, �if then� or some form of Posting.
Attached a �.exe cut-down booking form and calendar �browse form�
I somehow think that this problem and solution must be of interest to a whole bunch of people learning to use Alpha V.
Brianp.
Comment