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

If[ Not IsValid( rel::id ) ]

Custom Dialog

Else

GTRR ...

EndIf

-Jens

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

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!

What Ender said.

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

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

LOL! so not not IsEmpty() eh? :

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

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

it's only 1 off.

More in the metric system!

Lol, you guys crack me up.