Displaying date on another form once it is clicked on calendar
I am using a simple to understand 3 table database design to make a calendar and book simulator hours on given days.
ex fields in weeks table to make the calendar via a script
week date indexed auto-enter calculation, cmonth calc week-day(week) +1, cmonday = week +1 etc..
The calendar is made by running a months script.. When i click on a specific date i have a script to either take me to a daily view of bookings with instructors and 1 1/2 time slots for that day, or shift click and i can book a time slot for that day...
How to i get the date that i have clicked on say 25 July to be displayed on my appointment form when it opens...
I have tried to set the field from weeks::cmonday to events::eventdate; but doesn't work. also i saw in another sample database that the field was set to a say caldatecalc fields from 1-7 (for the 7 days, but i dont understand what the calculation is in the actual field in the table therefore i get errors. It was then set to a field calfilterdateglob before the appointment layout is opened. Tried it my layout is opening but no date is displayed. Am i missing a step, is there an easier way say $day variable which i tried but not working either..... Any help would be much appreciated..
This sounds like the calendar demo file I uploaded to:
Is this the file? If not, please describe your system in more detail as it is the relationships between each table and the design of your layouts that are key to getting this to work.
Is this the file?
If not, please describe your system in more detail as it is the relationships between each table and the design of your layouts that are key to getting this to work.