Check for valid event in a calendar

[Lee Baird]

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.

[David Holmberg]

This works for me...

If(count(fileB::anyfield)>0)

go to related record

Else

Show dialog box

End If

[-Queue-]

not IsEmpty(relationship::keyfield) will be faster, especially if there may be more than one related record.