Title
Multiple find criteria
Post
Hi Everyone
Please help me figure this out. I have a database that I schedule my photographers to photograph schools. I have 21 photographers who need to know where they have to be on any particular day. Here is some of the fields I have:
School name
Shoot date
retake date
photographers
Confirmed
Tentative
Main_Retake_Cal (This is a calculation field for fining Main shoot or Retake purposes)
Start_date
End_Date
I wrote a script that will find the schools that their retake date has be scheduled and confirmed and the script will no longer show the original shoot on the list. (Awesome if the shoot has happened already)
However I need it to show the shoot date as well as retake date if the shoot date has not yet happened.
This is my script:
Enter Find Mode [Restore]
Set Filed[School_Info::Main_Retake_Cal;School_Info::Start_date::&...&School_Info::End_Date]
Perform Find[]
Please help
Thanks
Enter Find Mode [Restore]
Set Field[School_Info::Main_Retake_Cal;School_Info::Start_date::&...&School_Info::End_Date]
New Record/Request
Set Field[School_Info::Shoot date;School_Info::Start_date::&...&School_Info::End_Date]
Perform Find[]
This, like your original script, will only work if start_date and End_Date have global storage specified.
By using New Record/Request to create a new request, this find will find all records matching the first criteria (on the Main_Retake_Cal field) OR if they match the second criteria (on the Shoot Date field).