0
    
          
  
  
    
            Table Constraints
I am trying to create a table constraint.
I have a table named transaction, with a debit account, and a credit account, to move money from one, to the other.
In the accounts I have a users field named "Ninox User" in the debit account, I want the constraint to only show the accounts of the user logged in.
So I am doing:
a.'Debit (From Account)'.'Ninox User'=
but what do I put for it to equal the current user?
3 replies
- 
  
Bump
 - 
  
Hi, we just started a SIG (special interest group) on accounting. This is a weekly regular webinar.
 - 
  
actually you can try:
user()
This returns the logged in user.
 
Content aside
- 6 yrs agoLast active
 - 3Replies
 - 2253Views
 
