Use Date Field in Related Table
I would like to use the date field in a related table to base my calendar view on. Is this possible? Following is the script for the view:
calendar "Upcomingtrials_Synergene"
{
show all rows from Entries [(Entry_Complete == false && Producer == "Synergene")]
(
TrialID_Entries as "Trial ID"
Variety
TrialID_Entries.Planted
TrialID_Entries.EHD
TrialID_Entries.Evaluator
TrialID_Entries.Region
TrialID_Entries.Commodity
Added_Time as "Added Time"
Harvest_Date as "Harvest Date"
)
group by
(
TrialID_Entries.EHD ascending
TrialID_Entries ascending
)
options
(
show calendar based on Harvest_Date
)
}
Under options I would like to use TrialID_Entries.EHD instead of Harvest_Date.
smspdd