Hi,
Here's my scenario:
I'm using the LLlbgen Designer and Llblgen run-time engine version 3.
I have a "domain" table (Llblgen Entity) for my web-application. Each domain (a company account) has multiple (user) Logins.
Tables (Llblgen Entities):
Domain - Columns: Id, UsesMyIndentityProvider (boolean)
Login - Columns: Id, DomainId (m logins for 1 domain), LoginName
Each Login table has a LoginName field (the user's login name). In the Login table, the composite of LoginName + DomainId has a unique key defined.
All is good so far...
Here's what I'm trying to achieve:
A Login.LongName needs to be unique across all Domains where Domain.UsesMyIdentityProvider = true, need to be unique.
I'm looking for a "constraint" like: Unique Key where Login.LoginName is unique where Domain.UsesMyIdentityProvider == true.
Can I set this up as a "Custom Relation" in Llblgen?