Hide Button for Operation with Records on Query

Jhstephenson

I have a Client Query. On it I have a button in the Operations with Records that will go to a Case Query for the Client; No problem so far.

I want that button though to only show up if there are actually Cases for the Client. I tried putting the following in the "Applicable when" property...

ClientMaster.child_CaseMaster IS DEFINED

But now the button doesn't show up at all regardless of whether or not there are Cases attached to a Client.

I know this has to be simple, but what am I missing here?

Jaymer

don't think you can check a reference field there - try a shortcut

Jhstephenson

I have tried putting a shortcut point to the Case BO from the Client but Aware doesn't seem to like that. What I may do is just put a CaseCount attribute in the Client BO and count how many there are and use that.

Rennur

In the BO Client, add a Yes/No attribute HasCase
Add a rule to check for if Cases exist:

If Client.Case IS DEFINED Then 
Client.HasCase='Yes' 
Else Client.HasCase='No'

Use the HasClients flag as a condition in the query menu.

Client.HasCase='Yes'