I have a jobs page, on this page are two portals, "Job by Days" and "Job Kilometres Report". I want a popup to advise to add details to the Job Kilometres Report when I add a job in the Job by Days portal. I was think that when I leave this Job by Days portal it can check to see if there is a date the corresponds to this date in the Job Kilometres Report, and if not a popup warning/advise appears to prompt for the Job Kilometres Report to be filled in.
How do I do this, I tried an "If" Job by Days::Date Worked does not equal Job Kilometres Report::Date script but this goes to the first job in database, not the job I am entering data for. Any help here would be appreciated. See attached screen capture.