AND statement in criteria for retrieving records
I am creating a training and mission database for my search and rescue team where users will input their own hour and mileage information referencing another form that has the training and mission data.
In the user input form I have a drop down list for either "Mission" or "Training". Depending upon their selection I would like to populate a dropdown list based upon this as well as the date. I tried the following on user input in the "Type" field:
for each m in Training_Info [(Type == input.Type && Year1 == input.Year)]
{
Select_Training_Mission:ui.add(m.Mission_Training_Name);
}
I can send the details, but both Year1 and Year reference numerical data that was generated by the .getyear() function.
When I include the year condition I get all events whether they have been flagged as a mission or a training. If I remove the year statement then I get them sorted correctly, but I need to segregate the missions and training based upon the year or else the list will get confusing.
Any ideas?