When a Form with an embedded view does not show an entry (according to the limitations in single category) I would like to display either a text in the form or open a messagebox.
How can I recognize weather the embedded view does display an entry?
stephan
Subject: Embedded view - show single category
I had a similar need, and solved it by placing a computed for display field above the embedded view. The field performs a lookup based on the category. If the lookup is successful, it returns a null value (because the embedded view data is visible). If the lookup returns an error, the field displays a message to the user.
a := @If(@DbLookup(“”:“NoCache”;@DbName;“viewname”;keyvalue;col#));
@If(@IsError(a);“Message to your user”;a)
It’s probably not the most elegant solution, but it works well in my application. Hope this helps!