You might want to download and examine this simple calendar demo file: http://www.4shared.com/file/6UAOV_RZ/Calendar.html
Feel free to post back here with questions if there's some part of it's design that you don't understand.
You can set up all your date fields as buttons. In button setup, you can specify a script parameter. If you enter the name of the field you just set up as a button, you can pass the date in the date field as a parameter to the script. Your script can then use a step like this:
Set Field [YourTable::FieldToStorerSelectedDate ; Get ( ScriptParameter ) ]
Note: sometimes script parameter values end up as text and this may be the case here. If you find this step doesn't work try it this way:
Set Field [YourTable::FieldToStorerSelectedDate ; GetAsDate ( Get ( ScriptParameter ) ) ]
Thanks for your help, Phil.
The Set Field idea is great. But I cannot seem to figure out how to make it all work. I am using 2 tables.
Table 1 is Year Overview and it contains records of the Courses.
Table 2 is Classes Database and it collects classes related to the courses.
My new question now is, which table should these date buttons originate?
I have tried from both, but always the same result...a new record with only a date in the Classes Database.
Actually, I am not at all clear on how to make this script work. It should allow me to click on a date button (from Year Overview) and have it create a new record in Classes Database using the chosen date, along with passing all related info from Year Overview into the Classes Database...like Course ID, Course Name, Course Teacher, Default starting time, default room, etc.
but, so far, it only gives me a new record with the right date.
Thank you again for your help...as always.
What am I missing here? I just can't see it.
Set Variable [$CourseID ; value: Year Overview::CourseID ]
Go To Layout [Classes]
Set Field [classes::CourseID ; $CourseID ]
Set Field [classes::Date ; Get ( ScriptParameter ) ]
I don't recommend putting "Course Name, Course Teacher, Default starting time, default room, etc." into the classes table unless these values might be different in each class record for a given course. If that is the case (such as your starting time), set a looked up value field option on this field in classes set to use this CourseID based relationship to look up the value from the Year Overview table.