Display informational message if there is no related record

[BeckyMN]

I have a simple two table database. What I would like to do is have a button that will take the user to the related record if there is one but if there is not a related record then I want to pop up the custom dialog box.

Can someone explain how is this done? It seems pretty simple but I can't get it to work.

Thank you!

Becky

[jteich]

If[ Not IsValid( rel::id ) ]

Custom Dialog

Else

GTRR ...

EndIf

-Jens

[Ender]

Use "not isempty()" instead of "not isvalid()". IsValid() is not intended for this purpose.

[BeckyMN]

That worked. I even looked at IsValid in the help file before posting but didn't realize that it did this from the description.

Thank you Jens!

[comment]

What Ender said.

[BeckyMN]

IsEmpty works too, but I had to remove the "not" modifier to make it work properly.

I thank all of you for your help. I learned something today. Now if I can just remember it for next time.

Becky

[comment]

LOL, you are right - it should have been "What Ender not said."

[Genx]

LOL! so not not IsEmpty() eh? :

[Ender]

Oh, you boolean logic freaks. IsEmpty(), not IsEmpty(), it's only 1 off. :

[comment]

Seriously, not not TRUE = TRUE. "not not" was a good way to do what GetAsBoolean() does now.

[comment]

it's only 1 off.

More in the metric system!

[Genx]

Lol, you guys crack me up.