November 7, 200421 yr I have a calendar solution (file A) that shows events from file B by having a different realtionship for each day of the month. When I select a date on the calendar, it goes to the related record in file B. But when I click on a date that does not have an event it still goes to the last date selected in file B. Instead I want a custom dialog box to pop up saying "This date does not exist. Would you like to add it? I know how to script the dialog box and the choices. I can't figure out how to check for a valid date in the calendar (file A) with a valid date in file B.
November 7, 200421 yr This works for me... If(count(fileB::anyfield)>0) go to related record Else Show dialog box End If
November 7, 200421 yr not IsEmpty(relationship::keyfield) will be faster, especially if there may be more than one related record.
Create an account or sign in to comment